OptionMetrics · 2 days ago

Database Administrator (DBA)

United States

Full-time

Remote

Mid Level

3+ years exp

Wonder how qualified you are to the job?

Maximize your interview chances

AnalyticsFinance

Insider Connection @OptionMetrics

Discover valuable connections within the company who might provide insights and potential referrals, giving your job application an inside edge.

Responsibilities

Manage and administer MSSQL and PostgreSQL databases to ensure stability, availability, and performance

Develop and optimize SQL queries for efficient data retrieval and manipulation

Design and maintain complex stored procedures, triggers, and views to meet business requirements

Install, configure, and monitor PostgreSQL databases, addressing any issues that arise

Implement and maintain database security measures, including user access controls and data encryption

Develop and execute backup and recovery strategies to minimize data loss

Utilize Amazon AWS services for database deployments, monitoring, and scaling

Collaborate with cross-functional teams to troubleshoot and resolve database-related issues

Utilize Git/GitHub for version control and collaborative development

Assist in data warehouse design and implementation, including ETL processes and reporting requirements

Stay updated with advancements and best practices in MSSQL, PostgreSQL, Amazon AWS, and related technologies

Qualification

Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.

MSSQLPostgreSQLSQLQuery OptimizationPerformance TuningStored ProceduresTriggersDatabase DesignDatabase MaintenanceInstallationConfigurationTroubleshootingAmazon AWSEC2RDSS3GitGitHubVersion ControlDatabase SecurityProblem-SolvingCommunicationInterpersonal SkillsCollaborationMicrosoft Azure