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