M.C. Dean is Building Intelligence™. We design, build, operate, and maintain cyber-physical solutions for the nation’s most recognizable mission-critical facilities, secure environments, complex infrastructure, and global enterprises.
Our success relies on great people delivering innovative projects and solutions for Fortune 100 companies and the most recognized agencies in government, defense, and security.
Join our more than 3,600 employees worldwide who engineer and deploy automated, secure and resilient power and technology systems; and deliver the management platforms essential for long-term system sustainability. Together we are creating the integrated systems and technologies that shape the built and cyber-physical world.
We offer an excellent benefits package including:
- A competitive salary
- Medical, dental, vision, life and disability insurance
- Paid-time off
- Tuition reimbursement
- 401k Retirement Plan
- Military Reserve pay offset
- Paid maternity leave
Database Administrator – SQL Server
Position Summary
Administers, manages, designs, documents, and evaluates a variety of database management systems; performs complex technical, analytical and professional services involving program/member services, evaluation, database-driven Web sites, office operations support, and problem resolution.
Responsibilities:
- Install and maintain the performance of database servers.
- Develop processes for optimizing database security.
- Set and maintain database standards.
- Manage database access.
- Performance tuning of database systems.
- Install, upgrade, and manage database applications.
- Perform data modeling and optimization, preliminary data received from customer designs, data analysis, report writing from existing data using SQL (Structured Query Language) queries, and creation of new records and information updates as needed.
- Responsible for installation and management of software.
- Perform installation and maintenance of data into primary and third-party applications provide technical support to and training to members of the team.
- Perform feasibility studies, cost/benefit analysis, and user training in response to user requests. Perform team leader functions for projects involving multiple parties: manage deadlines; provide status reports; facilitate final testing and project sign-off.
- Responsible for backup of all local databases and file directories applications, in coordination with the IT Manager.
- Diagnose and troubleshoot database errors.
- Recommend and implement emerging database technologies.
- Create and manage database reports, visualizations, and dashboards.
- Create automation for repeating database tasks.
- Be available for on-call support as needed.
Skills & Requirements:
- Applicants selected will be subject to a government security investigation and may meet eligibility requirements, including U.S. Citizenship, for access to classified information; DoD Secret clearance is required.
- Bachelor's degree with 10-12 years of experience
- DoD 8750 LAT Level II Certification (CCNA Security, CySA+, GICSP, GSEC, Security+ CE, CND, SSCP)
- SQL Server Certification
- Experience with SQL server administration
- Experience with active SQL Server clustering
- Scripting and reporting experience
- Experience with SQL Server patching
- Experience with technologies such as SCCM, WSUS, and virtual environments.
- Strong command of SQL and SQL server tools
- Advanced knowledge of database security, backup and recovery, and performance monitoring standards
- Understanding of relational and dimensional data modeling
- PowerShell and Unix shell scripting skills
- Familiarity with SSAS, SSIS, SSRS
- Strong mathematical and statistical knowledge
- Excellent written and verbal communication skills
- Impeccable attention to detail
Abilities
- Exposure to computer screens for an extended period of time.
- Sitting for extended periods of time.
- Reach by extending hands or arms in any direction.
- Have finger dexterity in order to manipulate objects with fingers rather than whole hands or arms, for example, using a keyboard.
- Listen to and understand information and ideas presented through spoken words and sentences.
- Communicate information and ideas in speaking so others will understand.
- Read and understand information and ideas presented in writing.
- Apply general rules to specific problems to produce answers that make sense.
- Identify and understand the speech of another person.
|
