SQL Database Administrator

Job Title**:Database Administrator (DBA)**
Department: Technology & Data Science
Location**:Gurugram**
Level: [**5-8 Years**]
Expected CTC: 15-16 Lakhs

**Job Summary**:
**Key Responsibilities**:

- **Database Administration & Optimization**:

- Manage and administer Microsoft SQL Server and MySQL databases.
- Optimize stored procedures and queries for performance improvements.
- Implement clustering, replication, and high-availability solutions for database infrastructure.
- Perform database backups, recovery, and disaster recovery planning.
- **Database Architecture & Modernization**:

- Redesign and optimize existing database architecture to enhance performance, scalability, and reliability.
- Evaluate and implement modern database solutions (SQL and NoSQL) based on business requirements.
- Provide recommendations on the best-suited database type (e.g., MongoDB, Redis, PostgreSQL) for different use cases.
- Implement database solutions for microservices-based architectures.
- **Data Integration & ETL**:

- Design and implement ETL pipelines for seamless data movement between different database systems (e.g., MSSQL to MySQL, MySQL to MongoDB).
- Ensure data integrity and consistency across multiple database environments.
- **Data Lake & Cloud Database Solutions**:

- Knowledge of Hadoop Data Lake, cloud-based data lakes such as AWS S3 Data Lake, Azure Data Lake, and Google Cloud Storage.
- Implement and manage data lake solutions to store and analyse large-scale datasets.
- **Database Security & Compliance**:

- Implement robust database security practices, including encryption, access control, and auditing.
- Monitor and mitigate database vulnerabilities and security risks.
- **Performance Monitoring & Troubleshooting**:

- Conduct database performance analysis and troubleshooting.
- Utilize monitoring tools to proactively identify and resolve database performance issues.
- Work closely with development teams to optimize database queries and indexing strategies.

**Required Skills & Qualifications**:

- **Strong database administration skills in Microsoft SQL Server and MySQL.**:

- Experience in **query optimization, indexing strategies, and stored procedure tuning.**:

- Hands-on experience with **database clustering, replication, and failover strategies.**:

- Experience with modern database technologies such as **MongoDB, Redis, PostgreSQL, Cassandra.**:

- Experience in **ETL processes**and data migration between different database systems.
- Understanding of database solutions for microservices architectures.
- Familiarity with **cloud database services AWS S3 Data Lake, Athena, Google Cloud Storage, Big Query.**:

- Proficiency in scripting and automation **(PowerShell, Python, or Shell scripting).**:

- Strong knowledge of backup, recovery, and disaster recovery best practices.
- Understanding of database security, encryption, and access control mechanisms.
- Experience with database monitoring tools (e.g., **Prometheus, Grafana, SQL Profiler, Percona Toolkit).**

Preferred Qualifications:

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

- Certifications such as Microsoft Certified: Azure Database Administrator Associate, AWS Certified Database - Specialty, or MySQL Certified DBA.
- Experience in data warehousing and big data processing.
- Familiarity with containerized database deployments using Docker and Kubernetes.
- Prior experience in NoSQL and hybrid database environments.

**Job Types**: Full-time, Permanent

Pay: ₹1,400,000.00 - ₹1,600,000.00 per year

Schedule:

- Day shift

Application Question(s):

- Your current designation?
- Current ctc and expected ctc?
- Notice period?

**Experience**:

- Database administration: 5 years (required)
- Microsoft SQL Server: 5 years (required)
- MySQL: 5 years (required)
- Database architecture design: 5 years (required)

**Location**:

- Gurugram, Haryana (required)

Work Location: In person