Previous Job
Previous
SQL Database Administrator
Ref No.: 17-00691
Location: Southfield, Michigan
Position Type:Contract
Start Date: 12/11/2017
Job Description:
  • SQL DBA Relevant Experience: 8 yrs +
  • Should have worked in L1/L2/L3 Production Support Projects
  • Should be very strong in his core SQL DBA skills
  • Experience with MS SQL Server 2005, 2008, 2008 R2, and 2012
  • Experience with SQL Server Mirroring and Replication
  • Experience with SQL Server Clusters
  • Strong troubleshooting skills for resolving various performance issues and tuning.
  • Experience in Database backup, recovery and disaster recovery concepts
  • Experience in Performance Tuning and Optimization, using monitoring and troubleshooting tools
  • Strong experience in managing database security, user accounts and access privileges
  • Ability to work independently and provide time estimates for database related tasks
  • Strong troubleshooting and customer service skills.
  • Perform data migration, and redaction utilizing approved tools and process
  • Monitor database for growth and respond to any application issues
  • Develop capacity model based on requirements
  • Identify and recommend changes to poorly performing SQL to the application developers, object statistics gathering, data level migration, schedule application jobs to perform data housekeeping and maintenance
  • Review and recommend efficiencies in application design as it relates to the operationalization of the applications.
  • Define, maintain and implement database infrastructure level standards (naming, coding, security, SQL, databases objects).
  • Provide feedback sessions to application users concerning database design.
  • Design indexing, referential integrity, constraints, data types, database objects (tables, views, indexes, stored procedures, triggers).
  • Maintain logical data models.
  • Provide logical/application database subject matter expert.
  • Work with application teams to define database object referential integrity.
  • Assist with the implementation of database implementations of scripted application codes.
  • Design physical database architecture (layout, distribution, placement).
  • Maintain physical models.
  • Maintain physical database documentation (instances, servers, databases).
  • Define database server connectivity configuration.
  • Define application and client server connectivity configuration.
  • Create and maintain physical database build scripts.
  • Execute physical data base build scripts.
  • Define database shutdown/startup procedures/scripts.
  • Define database application shutdown/startup procedures/scripts.
  • Define update statistics jobs