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.
