Home > Baton Rouge jobs > Baton Rouge computer/technical

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 is an interactive computer service that enables access by multiple users and should not be treated as the publisher or speaker of any information provided by another information content provider. © 2017