SQL Database Administrator / DBA

Job Duties:Perform data migration, and redaction utilizing approved tools and processMonitor 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.Basic qualifications and Must have :8 years SQL DBA Relevant ExperienceShould have worked in L1/L2/L3 Production Support ProjectsShould be very strong in his core SQL DBA skillsExperience with MS SQL Server 2005, 2008, 2008 R2, and 2012Experience with SQL Server Mirroring and ReplicationExperience with SQL Server ClustersStrong troubleshooting skills for resolving various performance issues and tuning.Experience in Database backup, recovery and disaster recovery conceptsExperience in Performance Tuning and Optimization, using monitoring and troubleshooting toolsStrong experience in managing database security, user accounts and access privilegesAbility to work independently and provide time estimates for database related tasksStrong troubleshooting and customer service skills.Posting Date:Department: -