Junior Database Administrator (MS-SQL)

Junior Database Administrator (MS-SQL) (Job Number:329964)

Description:

Junior Database Administrator for MS-SQL

Job Summary

The Junior Database Administrator (DBA) for MS-SQL reports directly to the Database Administration Team Lead and will provide Database Administration Services which are those activities associated with the installation, maintenance and support of existing and future database solutions and configurations. Performs database administration assignments essential to the production and development of Database Management Systems (DBMS) applications. Assignments which are in direct support of software development and maintenance teams, include database analysis, security support, design, software use, performance monitoring and tuning, and general technical expertise. Reviews and ensures integrity via standardized support tools. Completes assignments in accordance with established database administration guidelines, standards and procedures for applications development, implementation, testing, and migration. This position is located in the Orange County Data Center in Santa Ana, California. The Junior DBA for MS-SQL is a member of the DBA services team responsible for providing highly responsive, flexible database administration services to the County of Orange.

Key responsibilities:

- Provide database installation, performance tuning, and high-availability design/implementation database support for County of Orange.

- Install, configure and maintain database system software to support the normal business operation of County applications and other software components associated with databases.

- Manage database security and permissions IAW County policies.

- Define and execute database startup, shutdown, performance monitoring and tuning scripts, and keep databases running at optimal performance for the required workload.

- Implement and administer appropriate database management tools across all database instances.

- Perform appropriate database sizing activities and interface with Third Parties as required.

- Execute table space reorganizations on a scheduled basis.

- Create database indexes as requested by the County.

- Create and manage database and metadata profiles.

- Proactively identify and remediate bottlenecks for all database instances.

- Resolve locking conflicts, latch contention, rollback requirements, problematic SQL/processes etc. for all database instances.

- Provide technical assistance and subject matter expertise to County applications developers and Third Party vendor support.

- Perform database restores or recovery from export dumps or backups, archived logs or SAN.

- Open, track, and manage to resolution all database Incidents and Problems.

- Perform performance testing, database tuning, and threshold activities for both ongoing and project work.

- Collaborate with County in penetration test activities and perform database tuning to mitigate security risks identified in penetration test activities.

- Periodically run tools to determine and validate database integrity.

- Achievement of critical performance metrics including all contractually required Service Level Requirements (SLRs) on a 24x7 basis are a key focus of this position.

- Interfaces with customer application developers, storage system support personnel, and contract support personnel.

Qualifications:
Requirements:

- 4+ years' experience providing database administration services for MS-SQL environment.

- BA or BS degree or equivalent experience. Preferably in a technical field.

- Proficient in MS-SQL server configurations and associated tools, certifications beneficial.

- Experience working in commercial or local government business environments; experience working with Orange County preferred.

- ITIL V3 Foundations certifications beneficial.

- Excellent Communication Skills - written and oral.

- Ability to communicate effectively with all levels of personnel.

- Must be flexible in outlook and attitude.

- Excellent Presentation skills and ability to present to senior management.

- Excellent planning/time management skills.

- Excellent client-facing skills.

- Ability and willingness to think outside of the box to find creative and innovative solutions to reduce costs with a minimal impact on reliability.

- Location of work is Santa Ana, CA. Local candidate is preferred.

- California Department of Justice Background Investigation required.

Portions of SAIC to be renamed Leidos, Inc., subject to stockholder approval and consummation of a separation transaction if approved by SAIC board of directors. SAIC is pursuing a plan to separate into two independently traded companies: one that provides technical, engineering and enterprise information technology services primarily to the U.S. government (the new SAIC), and one that delivers technical solutions in national security, engineering and health (Leidos, Inc).

SAIC Overview:

SAIC is a leading provider of technical, engineering and enterprise information technology services to the U.S. government. Our 13,000 employees deliver systems engineering and information technology offerings for large, complex government programs, as well as a broad range of higher-end, differentiated technology services. The company is headquartered in McLean, Va..

Job Posting: Jul 19, 2013, 7:27:13 AM
Primary Location: United States-CA-SANTA ANA

Clearance Level Must Currently Possess: None
Clearance Level Must Be Able to Obtain: Other Clearance
Potential for Teleworking: Yes
Travel: None
Shift: Day Job
Schedule: Full-time