Job Description :

Hope you are doing great.!!!

I am attaching a job description for your review. If you are interested so please revert me back with your updated resume. Please call me on Ext: 118 or e-mail me at

Position: Sr Application Database Specialist
Location: St Louis MO
Contract – client would prefer a 6 month contract to hire
In person interview required

Essential Duties and Responsibilities:
Participates in the analysis and development of complex database designs, data models and relational data definitions in support of enterprise information system requirements (OLTP and OLAP
Focuses on enterprise-wide data modeling and database design. Creates logical and physical data models, mapping logical to physical. Creates the schema scripts and executes the DDL to build the structures.
Analyzes data requirements, application and processing architecture, data dictionaries, and database schema and then designs, develops, optimizes and certifies database schema design to meet system requirements.
In conjunction with application developers, implements database objects (tables, indexes, procedures, functions, etc based on approved data models.
Acts as the arbiter over the structure and contents of critical databases, establishing and enforcing rules, standards and guidelines.
Oversees the proper distribution and controlled replication of data across the enterprise. Identifies opportunities to reduce data redundancy
Ensures adequate security safeguards are in place to control access to all databases.
Maintains database dictionaries, standards and procedures, and integration of systems through database design.
Performs application tuning and performance monitoring.
In conjunction with other areas within IT, defines database backup and recovery plans.
Coordinates and monitors database reorganization schedules.
Implements data design enhancements and structure changes.
Coordinates changes with other areas within IT.
Performs a variety of other duties as assigned.

1. Candidates with good analytic and problem solving skills that have at least three years experience in RDBMS modeling and design.
2. Candidates with experience in postgreSQL, NoSQL technologies are preferred.
3. Candidates with experience working in scrum development teams using liquibase database change control process preferred.
4. Candidates with DB2 z/OS skills but willing to transition to open source database solutions including PostgreSQL, NoSQL etc.
5. Candidates willing to research and explore new database solutions and provide ideas.
6. Candidates with some java development background around database is very welcome.
Candidates with relational database systems experience especially on PostgreSQL and/or on DB2 zOS preferred along with experience working in an Agile/Scrum environment preferred.