Database Administrator
S
Smile Digital HealthHealth Data
United StatesFull-TimeMiddle
Salary110,000 - 125,000 USD per year
Apply NowOpens the employer's application page
Job Details
- Experience
- Five to ten years
- Required Skills
- PostgreSQLSQLMicrosoft SQL ServerMongoDBOracle
Requirements
- Post-secondary degree in computer science or related field.
- 5-10 years of experience in database administration, IT, or database architecture.
- Extensive experience with relational and non-relational databases including Oracle, MS SQL, PostgreSQL, and MongoDB.
- Strong command of SQL and database server tools.
- Expertise in database tuning, interpreting execution plans, and query optimization.
- Advanced knowledge of database security and performance monitoring standards.
- Understanding of relational modeling and strong mathematical/statistical knowledge.
- Experience with programming languages and troubleshooting connection strings/pools.
- Minimum 3 years of experience with Cloud Database Services (e.g., AWS RDS, Azure PostgreSQL).
- Minimum 2 years of experience with PostgreSQL maintenance tasks such as backup, restore, and multi-region replication.
- Experience with cloud services (AWS, Azure, OCI) and queuing services (Kafka, Eventhubs, ActiveMQ).
Responsibilities
- Perform database capacity planning, installation, configuration, design, migration, performance monitoring, security, troubleshooting, and backup/recovery operations.
- Serve as a subject matter expert for data management to troubleshoot and provide best practices for database implementation.
- Deploy, maintain, and support data systems for internal and external projects.
- Write and tune SQL queries and review schema designs for optimal performance.
- Implement and maintain DBMS and data maintenance pipelines/processes.
- Plan and execute data migration for complex systems with large datasets.
- Proactively recommend improvements for data systems.
- Collect and present data system metrics to internal and external parties.
- Collaborate with development, managed services, partners, and customers regarding database management practices.
View Full Description & ApplyYou'll be redirected to the employer's site