Overview
On Site
Depends on Experience
Contract - W2
Contract - 12 Month(s)
Able to Provide Sponsorship
Skills
Amazon Web Services
Amazon EC2
Database Architecture
Database Administration
Continuous Integration and Development
SQL
MongoDB
PostgreSQL
Extract
Transform
Load
Data Warehouse
Job Details
Looking for a Senior Database Management Specialist with the following experiences are required.
Summary:
- Design, develop, and maintain complex enterprise databases, data lakes, and data warehouses.
- Design complex database architecture, including data modeling, database schema design, and database security. Design, develop and implement plans for migrating data.
- Support implementation of data-centric, integrated software, hardware, cloud, and mobile solutions to meet system requirements.
- Provide database maintenance and operations recommendations for implementing complex web applications, data-sharing initiatives, reports, and dashboards.
- Review and provide expert support for database integrations to ensure operational and security compliance.
- Determine usage details and perform supporting tasks for implementing optimizations and cost-reduction strategies for database infrastructure, batches, and product deployments.
- Collaborate and consult with applications, infrastructure, and system operations teams to help automate the end-to-end operations of applications and systems in AWS Cloud.
- Develop standards and data scripts to monitor and alert various cloud-based systems and applications to help ensure Service Level Agreements and other performance metrics are met.
- Design, develop, and support Extract Transform and Load (ETL) processes to extract data from various sources, transform it to meet the needs of the organization, and load complex data elements into multiple databases, data lakes, and data warehouses.
Required Skills and Experience:
- A minimum of six (6) years of experience designing databases, queries, reports, and/or providing solutions for large-scale enterprise database requirements.
- A minimum of four (4) years of experience in a complex environment building complex data extractions, queries, or databases utilizing PostgreSQL, Informatica, and MongoDB.
- A minimum of four (4) years of experience with tools such as Bamboo, Jenkins, Maven, Bitbucket, Jira, GIT, etc.
- A minimum of four (4) years of experience in document management systems.
- A minimum of four (4) years of experience with supporting applications in a Cloud infrastructure on AWS (Amazon Web Services) and computing AMI virtual machines on Elastic Compute Cloud (EC2), continuous integration (CI), and Continuous deployment (CD) processes.
- A minimum of four (4) years of experience monitoring production database activities and batch jobs for operational improvements.
- A minimum of two (2) years of experience in large-volume database migration efforts.
- A minimum of four (4) years of experience in PostgreSQL Server database administration, patch management, maintenance, and/or writing complex SQL codes, stored procedures, and performing data extractions.
- A minimum of four (4) years of hands-on experience with performing database maintenance activities in production and/or lower environments.
- Experience with supporting installation and maintenance of databases for high availability. Strong understanding of database architecture and design, including normalization, indexing, partitioning, and replication.
- Experience managing and optimizing large databases, including performance tuning and capacity planning.
- Experience in data modeling, ETL processes, and data warehousing.
- Experience in SQL complex queries and batch performance optimizations.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.