Database Administrator PGSQL MSSQL
Database Administrator PGSQL MSSQL
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Job Description
Join a Montreal headquartered company that helps organizations around the world create a personalized journey of impact and fulfillment for their people. Explorance offers innovative Feedback Analytics solutions because we believe that each experience matters.
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 MSSQL Server to ensure the availability and consistent performance of our SaaS applications. This is a handson 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 databaserelated 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 datarelated 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:
- Bachelors 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 TSQL 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 problemsolving skills and attention to detail.
- Ability to work independently and as part of a team.
Preferred Skills:
- Experience with onpremise and cloudbased 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 getitdone 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 attheoffice culture.
At Explorance we take inclusion to heart and live it each day. We put the human first in everything we do and take pride in our authenticity and culture of inclusion. We therefore encourage persons of any race religion ethnicity gender identity sexual orientation age immigration status disability or other applicable legally protected characteristics to apply. We make employmentrelated decisions without regard to any of these characteristics. And to ensure a safe workspace for all our employees all employment is contingent upon receipt of a satisfactory background and reference check.
About Explorance
Explorance empowers organizations with nextgeneration feedback analytics to accelerate the insighttoaction cycle encouraging the philosophy of Feedback for the brave to drive purpose impact and growth.
Bringing 20 years of expertise Explorance a member of the World Economic Forum and a trusted partner for 35 of Fortune 100 companies and 25 of the worlds top higher education institutions has influenced over 25 million individuals with awardwinning solutions like Blue Metrics That Matter and MLY.
Consistently among the top employers by the Great Places to Work Institute Explorance a Brandon Hall AI award winner is also a twotime Global Leader in the 360degree feedback market by Fortune Business Insights.
Visitexplorance.comor connect onLinkedInFacebook andX.
Required Experience:
Senior IC
Employment Type
Full-Time
