Database Administrator
- Compensation
- Not disclosed
- Location
- Chennai, Tamil Nadu, India
- Work setup
- Onsite
- Seniority
- Not specified
- Employment
- Not specified
- Experience
- 5+ years
- Category
- Devops
- Posted
Skills
Must have
- Bachelor's degree in Computer Science, Information Technology, or a related field.
- 5+ years of experience as a Database Administrator with a strong focus on Microsoft SQL Server.
- Expert-level knowledge of T-SQL.
- Experience with database performance tuning and optimization.
- Experience administering Azure SQL Database environments.
- Experience with High Availability and Disaster Recovery technologies, including Always On Availability Groups.
- Experience working with Windows Server and Active Directory.
- Strong analytical, troubleshooting, and problem-solving skills.
- Ability to organize and plan work independently.
- Results-oriented team player with strong communication skills.
- Ability to work effectively in a rapidly changing environment.
- Ability to manage multiple priorities across geographically distributed teams.
Nice to have
- Experience with SSIS, SSRS, and SSAS.
- Experience with ETL processes and data integration.
- PowerShell scripting and process automation experience.
- Knowledge of Azure services such as Logic Apps, Elastic Jobs, Azure Analytics, and related services.
- Experience with PostgreSQL administration.
- Experience working with Microsoft OLAP architecture.
- Experience with database monitoring and observability solutions.
- Understanding of fundamental design principles behind scalable applications.
Full description
Applications are invited exclusively from individuals based in Chennai, who are prepared to work onsite at our office.
Explorance is a rapidly growing software company recognized for its unique workplace culture. We strive to be the best we can for our people, our customers, and the community. Currently, we are looking to add a Database Administrator (Intermediate) with a solid background in Microsoft SQL Server to join our growing CloudOps team.
Role Description:
As an Explorance DBA, you will be joining the Global CloudOps Team out of our Chennai office. You will be responsible for the implementation, configuration, maintenance, and performance of critical Microsoft SQL Server database systems to ensure the availability, performance, and security of our SaaS applications. This is a hands-on position requiring strong technical and troubleshooting skills, as well as excellent interpersonal and communication skills.
Key Responsibilities:
Database Administration & Implementation
- Install, configure, administer, and maintain on-premises Microsoft SQL Server databases across development, testing, and production environments.
- Configure, tune, and manage Azure SQL Databases and associated storage resources.
- Apply data modeling techniques to support integration, scalability, and performance requirements.
- Participate in database upgrades, migrations, and infrastructure improvement initiatives.
- Ensure high levels of database performance, availability, reliability, and security.
High Availability & Disaster Recovery
- Configure, monitor, troubleshoot, and optimize SQL Server Always on Availability Groups and clustering solutions.
- Develop, document, and implement backup and recovery strategies.
- Ensure disaster recovery readiness and data protection standards are maintained.
Performance Tuning & Optimization
- Monitor database performance and proactively identify bottlenecks and optimization opportunities.
- Analyze and optimize T-SQL queries, indexing strategies, and database configurations.
- Review deployment scripts and provide recommendations to improve performance and reliability.
- Utilize native SQL Server and 3rd party monitoring and troubleshooting tools to optimize database performance.
Security & Compliance
- Implement and manage database security controls, including Transparent Data Encryption (TDE), Change Data Capture (CDC), and auditing capabilities.