Job
Description
As a Database Developer/Engineer with 5+ years of experience in SQL Server and Oracle databases, your role will involve designing, developing, maintaining, and optimizing database solutions to support enterprise applications and data-driven systems. You will need hands-on experience in database programming, performance tuning, data modeling, and troubleshooting in both SQL Server and Oracle environments. Key Responsibilities: - Design, develop, and maintain database objects such as tables, views, stored procedures, triggers, functions, and packages. - Write complex SQL queries and PL/SQL code for data extraction, transformation, and reporting. - Implement and maintain data integrity, consistency, and quality across multiple systems. - Analyze and tune SQL queries and database performance for optimal speed and scalability. - Identify and resolve bottlenecks, deadlocks, and performance issues. - Collaborate with application and data teams to design logical and physical data models. - Implement efficient indexing and partitioning strategies to handle large data volumes. - Implement and maintain backup and recovery strategies using native tools or third-party utilities. - Ensure data security through user management, roles, and permissions. - Prepare and maintain documentation for database objects, procedures, and standards. - Collaborate with application developers to ensure smooth integration between application and database layers. - Support testing, release management, and production deployment activities. Qualifications Required: - 5+ years of hands-on experience with SQL Server and Oracle databases. - Strong proficiency in T-SQL and PL/SQL programming. - Experience with database design, normalization, indexing, and partitioning. - Proven expertise in performance tuning, query optimization, and troubleshooting. - Solid understanding of backup/recovery procedures, security, and database administration concepts. - Experience working in Agile/Scrum environments. Good to Have: - Experience with ETL tools (SSIS, Informatica, or similar). - Knowledge of data warehousing concepts and BI tools (Power BI, Tableau). - Familiarity with Cloud database services (AWS RDS, Azure SQL, or Oracle Cloud). - Exposure to DevOps/CI-CD pipelines for database deployment automation. (Note: Omitted additional details of the company as it was not provided in the job description) As a Database Developer/Engineer with 5+ years of experience in SQL Server and Oracle databases, your role will involve designing, developing, maintaining, and optimizing database solutions to support enterprise applications and data-driven systems. You will need hands-on experience in database programming, performance tuning, data modeling, and troubleshooting in both SQL Server and Oracle environments. Key Responsibilities: - Design, develop, and maintain database objects such as tables, views, stored procedures, triggers, functions, and packages. - Write complex SQL queries and PL/SQL code for data extraction, transformation, and reporting. - Implement and maintain data integrity, consistency, and quality across multiple systems. - Analyze and tune SQL queries and database performance for optimal speed and scalability. - Identify and resolve bottlenecks, deadlocks, and performance issues. - Collaborate with application and data teams to design logical and physical data models. - Implement efficient indexing and partitioning strategies to handle large data volumes. - Implement and maintain backup and recovery strategies using native tools or third-party utilities. - Ensure data security through user management, roles, and permissions. - Prepare and maintain documentation for database objects, procedures, and standards. - Collaborate with application developers to ensure smooth integration between application and database layers. - Support testing, release management, and production deployment activities. Qualifications Required: - 5+ years of hands-on experience with SQL Server and Oracle databases. - Strong proficiency in T-SQL and PL/SQL programming. - Experience with database design, normalization, indexing, and partitioning. - Proven expertise in performance tuning, query optimization, and troubleshooting. - Solid understanding of backup/recovery procedures, security, and database administration concepts. - Experience working in Agile/Scrum environments. Good to Have: - Experience with ETL tools (SSIS, Informatica, or similar). - Knowledge of data warehousing concepts and BI tools (Power BI, Tableau). - Familiarity with Cloud database services (AWS RDS, Azure SQL, or Oracle Cloud). - Exposure to DevOps/CI-CD pipelines for database deployment automation. (Note: Omitted additional details of the company as it was not provided in the job description)
