Navigant Consulting Inc Sr Database Administrator - Remote location in CHICAGO, Illinois
Navigant Consulting, Inc. (NYSE: NCI) is a specialized, global professional services firm that helps clients take control of their future. Navigant’s professionals apply deep industry knowledge, substantive technical expertise, and an enterprising approach to help clients build, manage and/or protect their business interests. With a focus on markets and clients facing transformational change and significant regulatory or legal pressures, the Firm primarily serves clients in the healthcare, energy and financial services industries. Across a range of advisory, consulting, outsourcing, and technology/analytics services, Navigant’s practitioners bring sharp insight that pinpoints opportunities and delivers powerful results. More information about Navigant can be found at navigant.com.
Collaborate with business clients and stakeholders to document business requirements and create database specifications.
Provide estimates and task planning as needed to support business cases and portfolio prioritization.
Respond to requests for database administration of corporate or business practice databases.
Work directly with applications owners and support personnel to maintain service level agreements.
Work with ETL and Application development team within DEV and UAT environments.
Install and deploy database solutions to achieve service level agreements.
Monitor and assess database performance and recommend tuning modifications to maintain service level agreements.
Participate in capacity planning for storage, servers and network components as needed to ensure performance and service level agreements.
Maintain up-to-date data dictionary and resolve data conflicts with users.
Provide on-call support for database support as needed to ensure operational and project objectives.
Stay current with database technology advances to enable production support and incident resolution.
Collaborate with analysts, developers, and end users to communicate and enforce standards and guidelines for data access and security.
Document databases in support of system development life cycle compliance.
BA/BS in related field and 8+ years’ experience with SQL Server database technologies, including SQL, T-SQL, SSIS & SSRS, & Windows. -SQL Server 2008 R2 thru SQL Server 216
Strong experience of relational databases, backup and restore operations, replication, locking, mirroring, clustering, DB logins/permissions, stored procedures, schema, triggers, database maintenance activity, etc.
Understands and has done database design & architecture.
Understands wait statistics, index maintenance, query performance tuning (query plans), long running queries, configuring meaningful SQL alerts.
Advanced knowledge of writing SQL and T-SQL scripts.
Run health-check scripts and able to execute process improvements based on results.
Understands and follows MS SQL Server best practices (Configuration, DB Security, etc.)
Experience with system development lifecycle methodologies, deliverables, controls
Experience with database monitoring tools such as Quest Spotlight.
Experience and knowledge of service oriented architecture preferred.
Background in system engineering (server, networking, security, etc.) preferred.
SQL Server IaaS and PaaS in Azure experience preferred.
Understands AlwaysOn configuration including older high availability options (mirroring, data replication, log shipping).
Healthcare experience preferred but not required.
MS SQL Server Certification preferred.
SQL Server developer experience is a huge plus.
Communicate frequently with co-workers as well as with managers to discern their needs, and be able to express themselves
Work as a member of a team as well as be a self-motivator with ability to work independently
Constantly operates a computer and other office equipment to coordinate work
Usually remains stationary for the majority of the day
Frequently communicates with clients and coworkers and must be able to share information effectively
Generally works in an office environment
The company offers competitive compensation packages including an incentive compensation plan, comprehensive medical/dental/life insurance, 401(k) and employee stock purchase plans.
Navigant does not accept unsolicited resumes through or from search firms or staffing agencies. All unsolicited resumes will be considered the property of Navigant and Navigant will not be obligated to pay a placement fee.
Navigant is an Equal Employment Opportunity / Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, color, national origin, ancestry, citizenship status, military status, protected veteran status, religion, creed, physical or mental disability, medical condition, marital status, sex, sexual orientation, gender, gender identity or expression, age, genetic information, or any other basis protected by law, ordinance, or regulation.
Navigant will consider for employment qualified applicants with criminal histories in a manner consistent with the requirements of applicable law or ordinance including the Fair Chance Ordinance of Los Angeles and San Francisco.