Information Technology (IT)
In this role you will provide SQL Server Administration support to the Defense Manpower Data Center (DMDC). automating the database operation and help streamline internal database processes. This person will help in database management, maintenance, and sustainment of the SQL Server, ensuring its operational readiness (security, health and performance) and supporting the development team. In order to be successful in this position you should have a good understanding of Windows Servers, DC, and Systems.
Responsibilities include but are not limited to:
Manage SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems.
Manage Always On, Disaster Recovery Environment, Replication and Azure connectivity.
Manage and main multiple Cluster environments.
Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.
Identify and fix SQL Server performance issues, query optimization and stored procedure performance improvement.
Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end.
Automate database task, Backup, Restore operations of production databases to other environment for testing and development purpose.
Assist developers with complex query tuning and schema refinement.
Provide 24x7 support for critical production systems.
Perform scheduled maintenance and support release deployment activities after hours.
Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members.
Knowledge of IIS and deploying pages and applications.
8 to 12+ years MS SQL Server Administration experience to include:
Experience with Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools.
Experience with backups, restores and recovery models.
Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server and Clusters.
Experience working with Windows server, including Active Directory, SSRS, SSIS and SSAS.
Previous Data center experience.
Ability to organize and plan work independently in a rapidly changing environment.
Mount indie is an Equal Opportunity Employer. We celebrate diversity, respect and seek to empower each individual and support the diverse cultures, perspectives, skills and experiences within our company. Mount Indie's commitment is to create an inclusive environment for all employees
Advanced Onion is a leader in the security and technology industries. With innovative approaches, unique experience and strategic vision there is no limit to the progressive services we put into action. As a Service Disabled Veteran Owned Small Business (SDVOSB) and a California Certified Disabled Veteran Business Enterprise (CA DVBE) we are positioned to add value through customized solutions and innovation, enhancing growth and upholding that competitive edge.