Database Administrator
Job Summary
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.
- Manage user access permissions and database security policies.
- Support compliance with organizational security standards and best practices.
- Monitoring & Automation
- Develop and enhance database monitoring solutions to improve visibility and operational efficiency.
- Automate routine database administration tasks using PowerShell and other appropriate tools.
- Continuously improve database operations maintenance procedures and documentation.
- Support capacity planning and resource utilization analysis.
- Troubleshooting & Support
- Diagnose and resolve production database issues in support of service-level objectives.
- Support application development teams with database design query optimization and troubleshooting.
- Perform scheduled maintenance and support release deployment activities as required.
- Follow and participate in Explorance development standards and guidelines.
- Collaboration
- Work closely with CloudOps Development and Infrastructure teams to support business initiatives.
- Collaborate effectively with global teams across North America EMEA and APAC.
Qualifications
- Bachelors 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.
Preferred Skills
- 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.
About Us
At Explorance we believe that the true power of experience lies in the moments that matter whether youre in the hiring process advancing in your career or navigating our technology. Were a company that not only takes diversity equity and inclusion to heart but lives it each day. We provide you with resources and support that fit your unique needs a workplace that reflects the wider world around us and a culture where you have a voice that is valued and empowered to succeed. Thats the kind of team youll be joining when you choose to work at Explorance. One where we choose trust over doubt responsibility over indifference choices over control and a personalized journey of growth and success over a traditional cookie-cutter employment storyline. SQL 2 Word
Are you curious to get to know more about our approach and products Visit our website: SQL 2 Word
Required Experience:
Senior IC
About Company
Explorance is a rapidly growing software company recognized for its unique workplace culture. Currently, we are looking for a Customer Success Manager to be based out of Amman, Jordan, to join our dynamic team who thrives in a demanding, fast-moving environment.