DBA Developer

We are looking for a highly skilled and experienced DBA Developer with 5 to 7 years of hands-on experience in database design, development, optimization, and administration. The ideal candidate will possess a strong blend of development expertise in SQL and PL/SQL (or T-SQL/PostgreSQL equivalents) combined with robust database administration skills. You will be responsible for ensuring the performance, integrity, and security of our databases, as well as developing and optimizing complex database solutions to meet business needs.

Key Responsibilities:

Design, develop, and implement complex database schemas, tables, views, stored procedures, functions, triggers, and other database objects. Write, optimize, and tune SQL queries and database code for maximum performance and efficiency. Perform database administration tasks, including installation, configuration, patching, upgrades, backup and recovery, and disaster recovery planning. Monitor database performance, identify bottlenecks, and implement solutions for performance tuning and optimization. Ensure database security, data integrity, and compliance with organizational standards and regulations. Troubleshoot and resolve database-related issues and production incidents promptly. Collaborate with application developers, architects, and business analysts to understand requirements and translate them into effective database solutions. Implement and maintain database replication, high availability, and disaster recovery solutions. Develop and maintain documentation for database designs, procedures, and standards. Participate in capacity planning and performance forecasting for database systems. Conduct code reviews for database scripts and provide constructive feedback. Automate routine DBA tasks and implement proactive monitoring.

Required Skills and Experience:

Bachelor s degree in Computer Science, Information Technology, or a related field. 5-7 years of progressive experience as a DBA Developer or a similar role. Strong expertise in at least one major relational database management system (RDBMS) such as Oracle, SQL Server, or PostgreSQL. o For Oracle: In-depth knowledge of SQL, PL/SQL, Oracle Forms/Reports, Oracle RMAN, Data Guard, RAC. o For SQL Server: In-depth knowledge of T-SQL, SSIS, SSAS, SSRS, AlwaysOn Availability Groups. o For PostgreSQL: In-depth knowledge of SQL, PL/pgSQL, replication, partitioning. o Expertise in MS SQL is required Proven experience in designing and implementing complex database schemas. Expertise in writing and optimizing complex SQL queries, stored procedures, functions, and triggers. Solid understanding of database performance tuning and optimization techniques (indexing, query plans, etc.). Experience with database backup, recovery, and disaster recovery strategies. Familiarity with database security best practices. Proficiency with database monitoring tools. Experience with version control systems (e.g., Git) for database scripts. Strong analytical and problem-solving skills. Excellent communication and interpersonal skills, with the ability to collaborate effectively with cross-functional teams. Ability to work independently and manage multiple tasks in a fast-paced environment.

Preferred Qualifications (Nice to Have):

Certifications in relevant database technologies (e.g., Oracle Certified Professional (OCP), Microsoft Certified: Azure Database Administrator Associate). Experience with NoSQL databases (e.g., MongoDB, Cassandra). Familiarity with cloud database services (e.g., AWS RDS, Azure SQL Database, Google Cloud SQL). Experience with scripting languages for automation (e.g., Python, PowerShell, Bash). Knowledge of data warehousing concepts and ETL processes.