Senior Systems Administrator

PSI Pax Port Hueneme, CA

PSI Pax is currently recruiting for a Senior Systems Administrator to support our government customer in Port Hueneme, CA.

Duties & Responsibilities:

The Senior Systems Administrator responsibilities include:

* Create stored procedures, triggers, and functions.

* Create complex analytic queries on large data sets .

* Analyze trends in key metrics.

* Generate code to extract, transform and load data from production data.

* Perform server maintenance to ensure efficient load processing.

* Performance tuning of key queries.

* Development, optimization, maintenance and support of core data repositories.

* Development of new projects and reports as part of the wider development team.

* Adherence / Enforcement of company Quality procedures.

* Regular and timely reporting to Team Leader and project managers as required.

* Write scripts to gather data from multiple data sources and perform various maintenance tasks.

* Coordinates operational designs, develops support plans, coordinates implementations and provides second level support for local area network (LAN), campus area network (CAN) and wide area network (WAN) solutions encompassing heterogeneous platforms.

* Leads and coordinates the operational support and implementation activities for local area network (LAN), campus area network (CAN) and wide area network (WAN) service offerings encompassing heterogeneous platforms.

* Assists leadership in determining tactical and strategic direction of the organization as it relates to emerging operational support technologies.

* Researches, analyzes and recommends new operational support technologies, tools, and techniques.

* Coaches others on the application of new operational support technologies.

* Reviews distributed computing and network designs to select appropriate operational support strategies and ensure efficient use of resources.

* Conducts system support design and performance evaluation reviews.

* Identifies, develops and updates operational support standards and procedures.

* Participates with corporate strategic planning teams.

* Keeps abreast of emerging operational support technologies and industry trends.

* Recommends price/performance improvement opportunities.

Required Qualifications:

* Security+ Certification

* Active Secret Clearance

* Candidates must be flexible to work any shift as this is a 24x7 environment

* Ten or more years of related experience.

* Two (2) years of experience in a database development role

* Recent experience with SQL Server 2005/2008/2012

* Extensive knowledge of T-SQL language

* Knowledge of principles of database design, data acquisition and data access analysis and design

* Knowledge of stored procedure writing, query optimization, and indexes

* Knowledge of database performance tuning techniques

* Must be knowledgeable in at least one procedural programming language (VBScript, PowerShell, C# .Net or

Preferred Qualifications

* SQL Server Reporting Services (SSRS)

* C#, .Net or VB.Net

* HTML / CSS / JavaScript

* VBScript

* PowerShell

* Knowledge of McAfee HBSS product

* Knowledge of MySQL

Education Requirement:

BS in Computer Science/Computer Information Systems or comparable experience.

PSI Pax is an Equal Opportunity Employer. Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, national origin, marital status, disability, veteran status, sexual orientation or genetic information.