Database Administrator (4-5 yrs)

Database Administrator.

Position Overview :

- We are seeking a highly skilled and motivated Database Administrator (DBA) to join our team.

- The ideal candidate will have extensive experience managing diverse database systems, including relational (e.g , MySQL, PostgreSQL) and non-relational (e.g , MongoDB, Cassandra, DynamoDB, Elastic Stack) databases on standalone servers or cloud platforms.

This role demands a proactive individual capable of designing, installing, maintaining, troubleshooting, and optimizing databases to support critical business applications.

The DBA will work closely with development and operations teams to align database strategies with organizational goals and streamline application database requirements.

Key Responsibilities :

- Database Installation and Management:.

- Install, configure, and maintain relational and non-relational databases on standalone servers and cloud environments.

- Monitor and optimize database performance to ensure high availability, scalability, and reliability.

- Diagnose and resolve database issues, implementing effective solutions promptly.

Migration and Transition Support :

- Plan and execute the migration of databases between environments, including standalone servers, cloud platforms (e.g , AWS, Azure, GCP), and hybrid setups.

- Design cost-effective and scalable database architectures to meet organizational needs.

(Good to know) ETL Processes and Big Data Handling :

- Develop, implement, and maintain ETL jobs to support data extraction, transformation, and loading requirements.

- Handle large-scale data pipelines and big data processing with a focus on performance and reliability.

Application Database Support :

- Collaborate with development teams to understand and support database requirements for various applications.

- Analyze and optimize database interactions within application code.

- Define and enforce database best practices, including schema design, indexing strategies, and query optimization.

Database Security and Compliance :

- Implement robust security measures to safeguard sensitive data.

- Perform regular database backups, recovery testing, and disaster recovery planning.

- Ensure compliance with data protection regulations and organizational policies.

Snapshots, Backups, and Performance Tuning :

- Design and maintain efficient snapshot and backup strategies to minimize downtime and data loss.

- Continuously monitor database performance and identify bottlenecks across diverse database systems.

- Conduct tuning activities to ensure optimal query performance and efficient resource utilization.

Optimized Database Schemas and Transactions :

- Create and maintain efficient database schemas to support business applications.

- Optimize transactions for high-volume applications to ensure consistency and reliability.

Documentation and Training :

- Maintain comprehensive documentation for database configurations, processes, and standards.

- Provide training and guidance to developers and stakeholders on database best practices and optimization techniques.

Required Skills and Qualifications :

- Bachelor's degree in Computer Science, Information Technology, or a related field.

- 4+ years of hands-on experience as a Database Administrator managing diverse databases (relational and non-relational).

- Proficiency in installing, configuring, and managing databases such as MySQL, PostgreSQL, Microsoft SQL Server, Oracle, MongoDB, Cassandra, Elastic Search on Linux or Windows servers.

- Expertise in ETL job design, big data handling, and database performance tuning.

- Experience with database migrations between cloud services (e.g , AWS, Azure, GCP) and standalone environments.

- Strong knowledge of database security, backup, snapshot, and disaster recovery strategies.

- Excellent troubleshooting skills for resolving complex database-related issues.

- Familiarity with application development processes and the ability to provide database-related recommendations.

- Strong communication skills and the ability to collaborate with cross-functional teams.

Preferred Qualifications :

- Experience with database monitoring, automation tools, and infrastructure as code (IaC).

- Knowledge of scripting languages (e.g , Python, Bash) for database automation and management.

- Familiarity with DevOps practices and CI/CD pipelines for database deployments