We are looking to add a Database administrator with a solid background in Postgres to join our growing CloudOps team.
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 RDBMS systems, specifically Postgres and MS-SQL Server, to ensure the availability and consistent performance of our SaaS applications. This is a hands-on position requiring solid technical skills, as well as excellent interpersonal and communication skills.
Key Responsibilities include:
Database Design Implementation
Design, install, configure, and maintain PostgreSQL and MS SQL Server databases, ensuring high levels of performance, availability, and security
Linux knowledge and bash experience
Implement database architecture and data models that align with business requirements.
Setup / monitoring / fixing / analyzing / troubleshooting high availability, including AlwaysOn, PG streaming replication and Active/Passive clusters
Performance Tuning Optimization
Monitor database performance, monitoring development and perform tuning and optimization tasks.
Analyze query performance and make recommendations for improvements.
Backup Recovery
Develop, document and implement backup and recovery strategies.
Ensure data integrity and availability through regular backups and disaster recovery plans.
Security Management
Manage user access and permissions to ensure data security.
Implement and monitor security measures to protect sensitive data.
Database security (e.g. TDE) and auditing abilities (i.e. CDC)
Troubleshooting Support
Diagnose and resolve database-related issues promptly in support of SLAs.
Provide support for application development teams and assist in database design and queries.
Documentation Reporting
Maintain documentation for database architecture, configurations, and processes.
Prepare regular reports on database performance and security.
Collaboration
Work closely with IT teams, application developers, and stakeholders to support data-related initiatives.
Participate in system upgrades, migrations, and other database projects.
Deployment code review and suggest performance enhancements
Follow and participate in Explorance development standards and guidelines
Qualifications:
Bachelor s degree in Computer Science, Information Technology, or a related field.
3+ years of experience as a Database Administrator, with a strong focus on PostgreSQL and MS SQL Server.
Proficient in PSQL, T-SQL, and other database programming languages.
Experience with database performance tuning and optimization techniques.
Familiarity with database backup, recovery, and disaster recovery processes.
Strong understanding of database security principles and practices.
Excellent problem-solving skills and attention to detail.
Ability to work independently and as part of a team.
Preferred Skills:
Experience with on-premise and cloud-based databases (AzureSQL).
Knowledge of Redis is a plus.
Experience with database monitoring tools and performance analysis.
Understanding of fundamental design principles behind a scalable application
Experience in SSIS / SSRS / SSAS
Experience in ETL
Flexible, team player with a get-it-done personality
PowerShell knowledge for process automation
Basic knowledge of Linux
Other Requirements
Only apply if you are a Chennai (or surroundings) resident that is interested in being part of a vibrant and highly engaged at-the-office culture.