Posted: Monday, October 30, 2017 9:17 PM
Role Title: Senior SQL DBAIMMEDIATE STARTRequired Skills:* Administering MS SQL Server 2008/2012/2014 instances* Demonstrates a strong understanding of database software and technologies including in depth knowledge of MS SQL 2014.* Design, implement, and maintain multiple SQL Server databases* Formulates and recommend technical direction for database related activities for the project teams in collaboration with other IT organizations.* Demonstrates a strong understanding of the database development life cycle including data modeling, implementation, and testing.* Demonstrates a strong understanding of performance tuning and optimization including the identification of performance related issues.* Demonstrates a working understanding of quality assurance and/or software development processes and methodologies, with the ability to share that knowledge with peers, and project team members.* Write complex SQL Queries, Procedures, monitor performance and tuning using SQL Profiler* Assist in developing the data model and populating the data dictionary* Register, extract and publish DACPAC projects for database objects deployment* Administering database backups and develop disaster recovery procedures as needed.* Controlling SAN storage allocation, and monitor availability.* Importing data from other DBMS for conversion to SQL Server* Managing and adhere to systems development life cycle processes and best practices* Effective communication to all levels within the organization as well as directly with customers on projects and / or issues with production systems.* Demonstrates a working understanding of Windows Server operating system.* Demonstrates a working understanding of working with multiple databases and hundreds of separate schemas.* Demonstrates a working ability to provide accurate project estimates and timelines.* Demonstrates a strong ability to deliver on project commitments.* Demonstrates an ability to manage multiple project deliverables on multiple projects effectively.* Demonstrates the ability to operate as the primary resource on a project, through planning, resource allocation, conflict resolution, project negotiation, and reporting. This individual should be able to manage the application through its entire lifecycle.* Demonstrates the ability to work with peers on project assignments.* Demonstrates a working ability to foster a cooperative environment with the entire project team. This resource is viewed as a team player, who understands the culture and how to be effective in it.Preferred Skills:* Bachelor's degree in one of the following subject areas: Computer Science, Business Administration, Information Technology, or related field preferred* Experience in a 24/7/365, multi-tiered production environment with very large databases* 10+ years of strong RDBMS experience with Microsoft SQL Server based products* 5+ years of experience in the following:* Publishing and maintaining logical data models with exposure to or experience in developing, validating, publishing and maintaining physical data models* Designing relational database models, as well as, developing complex and efficient database queries/stored-procedures, query tuning, index and statistics maintenance.* Installing, configuring and administering SQL Server instances in clustered mode to provide high availability and fault tolerance - including the ability to diagnose complex performance, configuration and operational issues and construct recommendations to the client* Strong understanding of database structures, theories, principles, and practices* Solid understanding of high availability architectures and MS SQL AlwaysOn Availability Groups* Well versed with writing and tuning T-SQL procedures and DTS/SSIS packages* Able to prioritize and execute tasks in a challenging environment* Strong communication and interpersonal skills are required.* Strong analytical, problem-solving and multi-tasking skills are required for the timely resolution of complex customer issues.* Strong business working experience is required to ensure tasks are completed without supervision.* Strong experience in a Microsoft centric environment is required to ensure a strong foundation in application support and troubleshooting.* Ability to monitor and report on multiple deliverables with a focus on meeting / exceeding deadlines.* Ability to occasionally work non-standard shifts and/or on-call to support the requirements of the organization.Expected Deliverable(s):Logical Data ModelPhysical Data ModelData DictionarySDL2017.
• Location: Baton Rouge
• Post ID: 30509587 batonrouge