Job Title: Database Administrator (DBA)
Job Summary:
We are seeking a Mid-Level Database Administrator (DBA) to manage and optimize relational and cloud-based database systems. The ideal candidate should have strong expertise in database administration, performance tuning, security management, and disaster recovery planning. This role involves monitoring, troubleshooting, and optimizing database performance, collaborating with development teams, and ensuring data security and availability.
Key Responsibilities:
- Install, configure, and maintain relational database management systems (RDBMS) such as MySQL, PostgreSQL, Microsoft SQL Server, and Oracle
- Monitor and optimize database performance, tuning queries, indexing strategies, and execution plans
- Develop and implement backup, recovery, and disaster recovery strategies to ensure data availability
- Manage user roles, authentication, and security policies to prevent unauthorized access
- Support data migration and ETL (Extract, Transform, Load) processes for integrating data across systems
- Troubleshoot database errors and connectivity issues, ensuring high availability and uptime
- Automate database maintenance tasks using scripting languages (Python, Bash, PowerShell)
- Collaborate with developers and DevOps teams to optimize database interactions in applications
- Ensure database compliance with industry regulations (GDPR, HIPAA, PCI-DSS)
- Document database architecture, policies, and troubleshooting procedures
- Stay updated with emerging database technologies, cloud-based solutions, and best practices
Skills and Knowledge Required:
- Strong SQL proficiency and experience with database administration, tuning, and query optimization
- Expertise in database security principles, including encryption, authentication, and access controls
- Experience with ETL processes, data integration, and data transformation
- Familiarity with cloud-based databases (AWS RDS, Google Cloud SQL, Azure SQL, Snowflake)
- Knowledge of database replication, high availability (HA), and clustering strategies
- Proficiency in scripting languages (Python, Bash, PowerShell) for automation
- Hands-on experience with database backup, recovery, and failover techniques
- Experience in monitoring tools (SQL Profiler, SolarWinds, New Relic, Nagios, Prometheus)
- Understanding of database governance and compliance standards
Educational Qualifications:
- Bachelor’s or Master’s degree in Computer Science, Information Technology, Data Science, or a related field
- Certifications in Database Administration (SQL Server, Oracle, AWS/Azure Databases) are a plus
Experience:
- 3-5 years of hands-on experience in database administration, performance tuning, and security management
- Experience in handling high-volume transactional databases and cloud database migrations
Key Focus Areas:
- Advanced Query Optimization & Performance Tuning
- Backup, Disaster Recovery & High Availability Strategies
- Security Management & Regulatory Compliance
- Cloud-Based & Hybrid Database Administration
Tools and Technologies:
- Database Systems: MySQL, PostgreSQL, Microsoft SQL Server, Oracle
- Query Languages: SQL, PL/SQL, T-SQL
- ETL & Data Integration: Apache NiFi, Talend, Informatica, SSIS
- Cloud Databases: AWS RDS, Google Cloud SQL, Azure SQL, Snowflake
- Monitoring & Optimization: SQL Profiler, SolarWinds, New Relic, Prometheus, Grafana
- Version Control & Automation: Git, Terraform, Ansible, Kubernetes, Docker
Other Requirements:
- Strong analytical and problem-solving skills for troubleshooting complex database issues
- Ability to mentor junior DBAs and collaborate with development teams
- Excellent documentation and communication skills
- Passion for database performance, automation, and security best practices