SQL Server DBA Contract to Permanent Job Redding, Ca.

Zeektek; California; Híbrido; USD 70.000 - 100.000; Jornada completa

Descripción de la vacante

Zeektek is seeking an entry-level to mid-level IT Database Administrator I for an onsite contract opportunity in Redding, CA with some remote flexibility. The role focuses on learning and performing SQL Server database administration tasks across production environments, upgrades, security, and disaster recovery planning.

The candidate will develop skills in backup strategies, performance tuning, and collaboration with developers to support complex business applications.

Formación

• Knowledge of relational databases and SQL Server DBMS architecture.
• Ability to develop and maintain backup/recovery procedures and security strategies.
• Experience with performance monitoring and query optimization.
• Familiarity with reporting tools such as SSRS/Crystal Reports.

Responsabilidades

• Learn and perform duties related to SQL Server database administration.
• Support production SQL Server environments and assist with upgrades.
• Develop and implement backup, recovery, and disaster recovery plans.
• Tune queries and optimize database performance with input from development teams.

Conocimientos

SQL Server

Transact-SQL

Database design

Backup and recovery

Performance tuning

Security concepts

Herramientas

SSIS

SSRS

DTS

Crystal Reports

SQL Server (DBMS)

Descripción del empleo

This is the entry-level/Mid Level SQL Server database administration contract Job opportunity Onsite work in Redding Ca with some remote flexibility

The IT Database Administrator I is capable of learning the skills necessary to be proficient in all aspects of SQL Server database management and administration and will have strong interpersonal and communication skills; is capable of explaining procedures in writing or verbally; and possesses good phone skills.

EXAMPLES OF ESSENTIAL DUTIES

Duties may include, but are not limited to, the following: This position requires the ability to: learn and perform a variety of tasks related to SQL Server database administration; research and respond to staff and management technical inquiries concerning SQL Server database management system (DBMS) environments; participate in the evaluation of available database hardware and software and facilitates adoption discussions; provide input on hardware, software, and other costs; participate in DBMS upgrades; develop, implement and maintains database backup and recovery procedures to ensure data integrity, security, and recoverability of data; prepare and implement business continuity and disaster recovery planning as it relates to SQL Server databases; develop, acquire, install, and maintain database performance measuring and reporting systems; analyze performance data to determine need for modification or addition to system configuration to meet current and future needs; confer and consult with management and other technical staff and vendors as required; create and maintain database documentation; participate in database security and security strategies; consider security at each phase of planning and design; participate in capacity planning to ensure that the database infrastructure is designed for current needs and future expansion; represent database support at meetings; work closely with development team to assist with design and implementation of SQL Server databases for complex business applications; assist with interface implementation to other systems; confer with IT management to ensure that proposed solutions are appropriate; perform other related projects and tasks as required/assigned.

Examples of specific duties: primary support of databases for specified vendor applications; to include administration, implementation, maintenance and ongoing support of production SQL Server database environments; work with leads in other functional areas to troubleshoot system problems when SQL Server databases are involved; install, patch, upgrade and test custom and vendor SQL Server software and databases; ad-hoc reporting and incident tracking; develop and debug SQL queries, stored procedures, and triggers; work with vendors and or developers to tune existing queries and configuration to improve performance or resolve performance issues; work closely with development team to assist with design and implementation of SQL Server databases for complex business applications; review proposed changes to databases to advise on performance impacts; provide support and suggestions for improving departmental processes; assist in the research and evaluation of support tools and methodologies.

EMPLOYMENT STANDARDS

Any combination of education and experience sufficient to directly demonstrate possession and application of the following:

Knowledge of: Relational databases, database design, and normalization; relational DBMS architecture; Microsoft SQL Server product family; security, system and object level privileges, roles and an understanding of how OS security options relate to the database environment; windows operating systems and networking; SQL Server administration and configuration; database performance management and monitoring tools and methods; SQL Profiler, Execution Plans; Transact-SQL; Data Transformation Services (DTS) and SQL Server Integration Services (SSIS); reporting tools; SQL Server Reporting Services (SSRS), Crystal Reports.

Ability to: Perform database problem resolution and cause analysis as well as recommend and implement preventative techniques; design, develop and maintain database and data transformation packages; create and update technical documentation; understand, translate and coordinate requirements into efficient usage of software and hardware products; demonstrate good time management skills by organizing work and desk space, managing priorities, meeting critical deadlines, and follow-up on assignments with a minimal of direction; adhere to and suggest improvements for standards in place at our organization for Database Management Systems; plan and implement changes to database systems; learn how to independently problem-solve; assess causes of database failures and initiate corrective action; establish and maintain effective working relationships with department staff, other departments, other agencies, and the public; communicate clearly and concisely, both orally and in writing; handle multiple tasks with shifting priorities.

MINIMUM QUALIFICATIONS

Three (3) years of database administrator experience. Successful completion of each thirty (30) semester units in an accredited college or university with an emphasis in programming, database, or related course work may be substituted for each one (1) year of total experience.