Manager of Database Administration

LUMINOUSTEC LLC; El Segundo (CA); On-site; USD 150,000 - 190,000; Full time

Job summary

Luminous Tec, LLC is seeking a seasoned Manager of Database Administration. You will lead production MSSQL Server clusters and a team of DBAs, shaping standards, procedures, and hands-on troubleshooting of performance issues.

Responsibilities include optimizing performance, ensuring high availability, and driving architecture improvements while mentoring staff and collaborating with IT leadership.

Qualifications

• Bachelor’s degree or equivalent experience required.
• Seven years’ MSSQL support in high availability OLTP.
• Five years managing DBAs in similar environments.

Responsibilities

• Lead development of standards, processes and procedures for database operations.
• Ensure optimal performance, availability and scalability of critical databases.
• Lead troubleshooting of database performance or stability issues.
• Identify sub-optimal architecture and lead remediation projects.
• Create monitoring standards for complete visibility of operations.

Skills

DBA management

SQL performance tuning

Root cause analysis

Analytical skills

Windows server administration

SQL development

High availability design

Database troubleshooting

Education

Bachelor’s Degree in Computer Science or equivalent

Tools

SQL Server Profiler

SSMS

PerfMon

DMVs

DTA

Job description

Luminous Tec, LLC is a leading staffing firm and provider of temporary and permanent staffing. We provide professionals on a project and full-time basis to our clients in different business verticals. To learn more about Luminous Tec's services, solutions, products, and locations go to www.luminoustec.com.

Job Description

One of our client is seeking a seasoned Manager of Database Administration. Reporting to the Vice President, Information Technology, this position is responsible for the management and availability of the Company’s production Microsoft SQL Server clusters and will oversee a team of DBAs responsible for supporting them. Client is seeking a manager who is not only expert on the technology and high performance database design, but also equally adept at managing high achieving teams, developing database standards and hands-on troubleshooting of SQL Server performance issues.

Responsibilities

• Lead the development of standards, processes and procedures (creating KBs, runbooks, topology) and ensuring consistency in operations
• Develop operations to ensure optimal performance, availability and scalability of all critical database environments at all times
• Lead the troubleshooting of any database performance or stability issues
• Identify sub-optimal database architecture, design, or operational practices and lead the execution of projects to address them
• Create monitoring standards and practices to ensure complete visibility of all database operations and supporting infrastructure

Qualifications

• Bachelor’s Degree in Computer Science or equivalent experience
• Minimum seven years’ experience supporting MSSQL server in a high availability, high transaction OLTP environment with a minimum of 5 years managing DBAs in similar environments.
• Excellent root cause and impact assessment skills
• Adept analytical skills with the ability to conduct methodical and well-reasoned analysis of performance issues
• SQL Server database engine on contemporary versions of SQL Server
• Demonstrable knowledge of how it operates along with strengths and weaknesses of the design/architecture and troubleshooting core database engine and configuration issues
• AlwaysOn architecture, clustering, mirroring, and transactional replication
• Indexes, index management, integrity checks, configuration, partitioning. How statistics work, how indexes are stored, how they can be created and managed effectively.
• SQL Server monitoring/performance tools (Profiler, DTA, SSMS, SAC, SSCM, PerfMon, DMVs, system sprocs)
• SQL Development – ability to write, review and troubleshoot SQL Code and design (stored procs, functions, tables, views, triggers, indexes, constraints )
• Windows server, security delegation, SPNs, storage and storage sub-systems
• Experience migrating SQL Server to a big data solution is a plus

Additional Information

• Interview will be in-person or on Skype
• Client will not pay relocation cost
• Selected individual will have to go through background / credit check