Data Engineer

The Database Administrator (DBA) plays a critical role in managing and maintaining the organization’s database infrastructure to ensure security, reliability, and optimal performance. This role is responsible for database design, performance tuning, backup and recovery strategies, and security management. The DBA will work closely with development teams, IT operations, and business stakeholders to support mission-critical applications and ensure data integrity.

As a key technical expert, the DBA will proactively identify and resolve database performance issues, implement high-availability solutions, and contribute to architectural decisions that align with business goals. The ideal candidate is a problem-solver with deep expertise in database technologies, automation, and best practices for modern data management.

Key Responsibilities:

Database Administration & Management

• Design, implement, and maintain highly available and scalable database systems (SQL Server, Oracle, PostgreSQL, MySQL, etc.).

• Monitor database performance, tune queries, and optimize indexes to ensure efficient system performance.

• Oversee database security, including user access, encryption, authentication, and regulatory compliance.

• Manage database backup, recovery strategies, and disaster recovery planning.

• Automate routine database maintenance tasks using scripts and database tools.

Performance Tuning & Optimization

• Analyze database performance metrics and identify bottlenecks.

• Optimize queries, indexes, and stored procedures to improve efficiency.

• Troubleshoot and resolve database-related performance issues.

Database Architecture & Development

• Design and implement database schemas, tables, views, and stored procedures.

• Collaborate with software developers to support database-driven applications.

• Develop and maintain data models, ensuring database integrity and normalization.

Security & Compliance

• Implement and enforce database security policies and best practices.

• Conduct regular security audits and vulnerability assessments.

• Ensure databases comply with industry regulations (e.g., GDPR, HIPAA, SOX).

Automation & Scripting

• Develop scripts for database automation, deployment, and monitoring.

• Implement DevOps practices for continuous integration and database version control.

Collaboration & Support

• Work closely with IT teams, software developers, and business analysts.

• Provide database expertise in system upgrades, migrations, and cloud adoption.

• Mentor junior DBAs and provide technical guidance.

Qualifications:

• Bachelor’s degree in Computer Science, Information Technology, or related field. 

• 5 years of experience as a Database Administrator (DBA), with at least 3 years in a DBA role. 

• Expert knowledge of SQL Server, Oracle, PostgreSQL, MySQL, or similar databases. 

• Strong skills in database performance tuning, query optimization, and indexing. 

• Experience with database replication, high availability (HA), and disaster recovery (DR) solutions. 

• Proficiency in backup and recovery strategies. 

• Knowledge of cloud databases (AWS RDS, Azure SQL, Google Cloud SQL) is a plus. 

• Hands-on experience with scripting (PowerShell, Python, Bash) and automation tools. 

• Strong understanding of data security, encryption, and compliance standards. 

• Familiarity with DevOps practices, CI/CD pipelines, and database version control. 

• Excellent problem-solving, troubleshooting, and analytical skills. 

• Strong communication and leadership skills.

Preferred Qualifications:

• Microsoft Certified: Azure Database Administrator Associate 

• AWS Certified: Database – Specialty 

• Oracle Certified Professional (OCP): Database Administrator 

• MySQL or PostgreSQL DBA Certification