AUTHORITIES / RESPONSIBILITIES :
- Provides SQL Server database administration in accordance with the respective OEM’s best practices
- Installation and configuration of SQL Server instances
- Creates and maintains documentation of database systems, operational procedures, topology, and hardware / software inventory
- Formulate and monitor policies, procedures, and standards related to database management
- Propose and implement enhancements that will improve the performance and reliability of the database systems
- Proactively monitor systems and alerts, using industry recognized tools to avert troublesome trends as they develop to ensure a stable production environment
- Perform routine consistency checks against databases
- Define access policies and enforce DB security
- Maintains asset records as required by the organization’s asset management process
- Participates in the organization’s change management process
- Documents problem resolutions into the appropriate systems
- Troubleshoots, analyzes and resolves system and user problems
- Plans, organizes and coordinates work assignments and prioritizes workload
- Rapidly deploys approved fixes to database management systems in response to newly identified stability and security threats
- Participates in compliance activities that include log collection, analysis and reporting
- Produce DBMS best practice oriented object naming conventions and ensure these conventions are disseminated to any object developer
- Review database objects that have been approved for Production environment implementation prior to release
- Work in conjunction with Application Development team on Product Delivery (Releases) into Production database environment
QUALIFICATIONS / KNOWLEDGE / EXPERIENCE :
REQUIRED :
Bachelor’s degree in related field or equivalent education / experience to successfully complete the assigned duties7 years’ experience administering a multi-server SQL Server environment3 or more years’ experience in technical lead role to IT projectsExperience in database designExperience in supporting multi-instance SQL Server 2005 – 2014 environmentsKnowledge and understanding of views, triggers, stored procedures, and query optimizationKnowledge of daily Windows server administration, including system stability, integrity, and troubleshootingKnowledge and understanding of SQL execution plansKnowledge of SSIS packages and ETLPractical knowledge of T-SQL programming languageTheoretical understanding of SQL Server DBMS objects and components, such as Temp DBs, System DBs, File Groups, Recovery Models and Transaction LogsTheoretical understanding of the SQL Memory architecture, such as Buffer Cache and Procedure CacheExperience with building SQL Server maintenance plansExperience in creating and scheduling SQL Server jobsExperience in building and administering highly available database solutions in SQL Server using the following technologies (replication, mirroring, and clustering)Experience with SQL Server’s Profiler, Data Tuning Advisor (DTA), DBMail, Extended Events and Activity Monitor tools both native and third party.Experience in executing backup and restorations of SQL Server databases using native and third party tools.Ability to understand and comply with relevant department and / or corporate policies, procedures and guidelines as they pertain to company data and technology servicesProficiency with current versions of Microsoft Word, Excel, Access, and PowerPointPREFERRED :
Knowledge and understanding of ITIL concepts such as Service Desk, Incident Management and Change ManagementManufacturing Industry experienceBasic knowledge and understanding of Microsoft programming languages such as Visual Basic and C#Oracle 10g or 11g DBMS experience a strong plusSAN and Storage experienceADDITIONAL GUIDELINES :
The ability to obtain and maintain a DoD clearance may be required if deemed
Necessary in the scope of your position responsibilities.
Candidates must meet the following employment eligibility guidelines to be considered for employment with Austal USA :
18 years of age or older at time of applicationAble to provide proof of US Person StatusNo felony convictions of Theft / Deception or Violent crimes within seven years from disposition dateNo felony convictions of Drug crimes within three years from disposition dateWilling to submit to a drug screenWilling to submit to a background checkEqual Employment Commitment
Austal’s commitment to equal employment opportunity applies at all levels of employment, in all job titles, including the executive level, and to all employment actions, including but not limited to decisions concerning recruitment, hiring, training, and promotion.