Database Administrator (Intermediate)

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

• 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.

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 you're in the hiring process, advancing in your career, or navigating our technology. We're 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. That's the kind of team you'll 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 Server...nistrator2 | Word]

Are you curious to get to know more about our approach and products? Visit our website: https://explorance.com/our-approach/explorers/. [SQL Server...nistrator2 | Word]