Previous Job
Previous
SQL Development DBA
Ref No.: 19-09246
Category: Experienced Professional
Location: Kansas City, Missouri
Position Type:Contract
Start Date / End Date: 11/08/2019 to 11/08/2020

 Genesis10 is actively seeking a SQL Development DBA for a long term contract position with a client in the transportation industry, located in KC MO.     
  • Must be a US citizen
  • Local candidates only
 
Description:
 
Will be responsible for providing database development, deployment, and code review services to the organization. This role requires deep skills in data design, modeling and normalization to ensure that database are designed and implemented following CICD process and to promote data integrity. This position will align with and support the company’s MDM and data governance strategy by creating and standardizing data systems, policies and procedures.
 

Responsibilities:
  • Review and improve current application DB development and deployment strategies. Focus on tasks related to building an effective, usable database environment to support the creation and maintenance of applications.
  • Work with Data Analysts in the process of data modeling and normalization to ensure that databases are designed to promote data integrity, then to translate logical data models and Erwin diagrams into a physical database implementation.
  • Develop the best practice of database CICD model and implement it in TFS
  • Create logical and physical data models using best practices to ensure high data quality and reduced redundancy.
  • Optimize and update logical and physical data models to support new and existing projects.
  • Recommend opportunities for reuse of data models in new environments.
  • Perform reverse engineering of physical data models from databases and SQL scripts.
  • Evaluate data models and physical databases for variances and discrepancies.
  • Analyze data-related system integration challenges and propose appropriate solutions.
  • Create data generation, editing, and refresh process to facilitate database and application testing
  • Work with the application development team to ensure that appropriate and efficient SQL is being coded and tested, and is built for performance during the development phase, instead of retrofitted later in production.
  • Review current database-coupled application logic – stored procedures, triggers, and user-defined functions (UDFs). Help to build, test, and maintain these objects, including source code management (TFS check-in/check-out), versioning, impact analysis, and code testing.
  • Other responsibilities include operational work, including participating in the weekly on-call rotation, incident management and prevention to ensure that service related issues are resolved quickly and efficiently, responding to database alerts, and general ticket requests.
Requirements: 
  • Strong understanding and experience in the use Visual Studio Database Projects, including creating, managing, and deployment of new code.
  • Strong understanding and experience in the use TFS Source Control and workflows, including process creation and automation of deployments.
  • Strong understanding of source control, branching strategies, GIT, etc. and how to apply to various projects within an organization.
  • Experience in Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools.
  • Strong understanding of good database development practices and T-SQL
  • Experience in implementing operational automation using scripts.
  • Experience with Azure SQL, Azure DW, DB2 environments.
  • Knowledge of backups, restores and recovery models.
  • Knowledge of High Availability (HA) and Disaster Recovery (DR) options for MSSQL Server.
  • Knowledge of indexes, index management, and statistics.
Preferred/Additional:
  • Experience optimizing code for tables with over 1 billion records.
  • Experience indexing strategies for 100+ million table environments in an AlwaysOn Replica setup.
  • Involvement with the MSSQL Server Community; membership in PASS, active in forums or newsgroups.
  • MCTS, MCITP, MVP certification
  • Experience with DB2, Oracle, and/or SAP environments
  • General understanding of Linux CLI commands
 

If you have the described qualifications and are interested in this exciting opportunity, please apply today! 

About Genesis10:
Genesis10 is a leading U.S. business and technology consulting firm with hundreds of clients needing proven talent and solutions to power their strategic initiatives. If you are a high performing business or IT professional with solid, referenced experience, we want to meet you. Genesis10 recruiters and delivery professionals are highly accomplished career advocates, who get to know you beyond your resume to position you with the opportunities that fit your skills, experience and aspirations. We have benefit options to fit your needs and a support staff that works with you from placement throughout your engagement – project after project. To learn more about Genesis10 and to view all our available career opportunities, please visit us at
www.genesis10.com
“Genesis10 is an Equal Opportunity Employer, M/F/D/V”