OptionMetrics · 2 days ago

Database Administrator

United States

Full-time

Remote

Mid Level

$100K/yr - $175K/yr

Maximize your interview chances

AnalyticsFinance

Insider Connection @OptionMetrics

Discover valuable connections within the company who might provide insights and potential referrals.
Get 3x more responses when you reach out via email instead of LinkedIn.

Responsibilities

Manage and administer MSSQL and PostgreSQL databases, ensuring their stability, availability, and performance.

Develop and optimize SQL queries to retrieve and manipulate data efficiently, improving system performance and response times.

Design and maintain complex stored procedures, triggers, and views to meet business requirements, ensuring data consistency and integrity.

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

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

Develop and execute backup and recovery strategies, minimizing the risk of data loss and ensuring business continuity.

Utilize Amazon AWS services, such as EC2 and RDS, for database deployments, monitoring, and scaling to meet business demands.

Collaborate with cross-functional teams, including developers and system administrators, to troubleshoot and resolve database-related issues promptly.

Utilize Git/GitHub for version control and collaborative development, ensuring proper code management and team coordination.

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

Stay updated with the latest 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.

MSSQLPostgreSQLSQL query optimizationStored proceduresAmazon AWSGit/GitHubDatabase securityETL processesDatabase installationDatabase troubleshootingData encryptionCross-functional collaboration