SQL DBA

Job#: 2076708

Job Description:

Job Description

Summary: The Sr Database Administrator performs database and software life-cycle activities to ensure highest level of system performance and availability in compliance with business requirements. This position partners with other Information Technology team members to accomplish planning, implementation and maintenance of database related infrastructure for legacy and new business application systems. This position is responsible for maintaining the integrity, security and availability of multiple database(s). Other key job duties include disaster recovery, performance analysis and tuning, index maintenance and monitoring of data.

Essential Duties and Responsibilities include the following. Other duties may be assigned.

• Creates, monitors, and maintains company databases by responding to a variety of internal and external database customer requests and assignments from management.
• Provides database back-up, archiving, monitoring, data analysis and troubleshoots data issues.
• Main responsibilities include working with company defined (MS SQL Server) software installations; user and schema creation, maintenance, and auditing; data mapping, loading, and quality control; backup and recovery; space and runtime performance tuning; monitoring and maintenance of data replication processes; and development of supporting scripts and procedures.
• Assists with related task planning, training and technical direction of other DBA's or IT software engineers and developers.
• Provides technical expertise for the organization's use of relational database and related technologies.
• Researches and recommends current and trending database technologies that offer the organization ways to improve its level of service to customers and maintains its leading edge over competitors
• Provides peer reviews for work produced by other DBA's and/or software engineers.
• Develops, documents, automates, and assesses DBA processes while looking for ways to improve current processes and streamline efforts. Trains others on the IT DBA Team and within the Information Technology department on databases related to repeatable processes.
• Provides on-call support after hours and on weekends (on a rotational basis) per the department's on-call agreement to meet SLA's and metrics.

Supervisory Responsibilities

No supervisory responsibilities.

Client Responsibilities

This is an internal and external client facing position that requires excellent customer service skills and interpersonal communication skills (listening/verbal/written). One must be able to; manage difficult or emotional client situations; Respond promptly to client needs; Solicit client feedback to improve service; Respond to requests for service and assistance from clients; Meet commitments to clients.

Qualifications

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Education and/or Experience

BS/BA and 8+ years' experience or equivalent combination of education and experience, and 4 years of SME in respective areas.

Computer Skills - Must possess solid skills in the following areas:

• Multiple programming languages and systems including those currently used in industry.
• SQL Server programming and databases, SQL, PL/SQL, SSIS, SSRS as well as a solid understanding of latest technologies and programming languages
• Thorough knowledge of software methodologies, distributed networking, databases, and multiprocessing applications
• Hardware architecture, disk arrays, drives and hardware capacity requirements.
• Oracle relational database architecture, design and maintenance
• Scripting tools including: AWK, KornShell (ksh), and PERL among others
• Unix, Linux and AIX operating systems
• Design, development, design patterns, and complete application development lifecycle
• Database interfacing and relational database management systems (RDBMS such as MS SQL or similar)
• High Availability and disaster recovery technologies including Always on or similar

Certificates, Licenses, Registrations

None required, but any of the following certifications are a plus:

• MSSQL Certification

Other Skills and Abilities

• Ability to work independently under general direction and as a cohesive team member with excellent interpersonal skills.
• Good verbal, written communication and presentation skills.
• Excellent organizational, attention to detail, and follow-up skills.
• Must be available for on-call work after-hours and weekend work as needed.

Reasoning Ability

Ability to solve practical problems and deal with a variety of concrete variables in situations where only limited standardization exists. Ability to interpret a variety of instructions furnished in written, oral, diagram, or schedule form.

Mathematical Skills

Ability to calculate figures and amounts such as discounts, interest, commissions, proportions, percentages, area, circumference, and volume. Ability to apply concepts of basic algebra and geometry.

Language Skills

Ability to read, analyze, and interpret general business periodicals, professional journals, technical procedures, or governmental regulations. Ability to write reports, business correspondence, and procedure manuals. Ability to effectively present information and respond to questions from groups of managers, clients, customers, and the general public.

Competencies

To perform the job successfully, an individual should demonstrate the following competencies:

• Analytical - Synthesizes complex or diverse information; Collects and researches data; Uses intuition and experience to complement data; Designs work flows and procedures.
• Design - Generates creative solutions; Translates concepts and information into images; Uses feedback to modify designs; Applies design principles; Demonstrates attention to detail.
• Interpersonal Skills - Focuses on solving conflict, not blaming; Maintains confidentiality; Listens to others without interrupting; Keeps emotions under control; Remains open to others ideas and tries new things.
• Teamwork - Balances team and individual responsibilities; Exhibits objectivity and openness to others views; Gives and welcomes feedback; Contributes to building a positive team spirit; Puts success of team above own interests; Able to build morale and group commitments to goals and objectives; Supports everyones efforts to succeed.
• Change Management - Develops workable implementation plans; Communicates changes effectively; Builds commitment and overcomes resistance; Prepares and supports those affected by change; Monitors transition and evaluates results.

Physical Demands The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

While performing the duties of this Job, the employee is regularly required to sit; use hands to finger, handle, or feel and talk or hear. The employee is occasionally required to stand; walk and reach with hands and arms. The employee must occasionally lift and/or move up to 10 pounds. Specific vision abilities required by this job include close vision, distance vision, color vision, peripheral vision, depth perception and ability to adjust focus.

Work Environment The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

While performing the duties of this Job, the employee is occasionally exposed to risk of electrical shock. The noise level in the work environment is usually moderate.

Work Location

This position must work on-site at the San Diego Headquarters or at the Tempe, Arizona site for purposes of providing adequate support to internal clients; being available for face-to-face interactions and coordination of work with other employees, colleagues, clients, or vendors; as well as for facilitation of quick and effective decisions through collaboration with stakeholders. Remote work is not an option for these purposes.

Working Hours

This is an exempt level position requiring one to work the hours needed to get the job done. Therefore one must have the flexibility to work beyond traditional hours and be able to work nights, weekends or on holidays as required. This may be changed from time to time to meet the needs of the business. Typical core business hours are Monday through Friday from 8:00am to 5:00pm.

Travel - This position may require domestic travel as well as attendance at various local conferences and meetings.

Apex Systems is a world-class IT services company that serves thousands of clients across the globe. When you join Apex, you become part of a team that values innovation, collaboration, and continuous learning. We offer quality career resources, training, certifications, development opportunities, and a comprehensive benefits package. Our commitment to excellence is reflected in many awards, including ClearlyRated's Best of Staffing in Talent Satisfaction in the United States and Great Place to Work in the United Kingdom and Mexico.

Apex Benefits Overview: Apex offers a range of supplemental benefits, including medical, dental, vision, life, disability, and other insurance plans that offer an optional layer of financial protection. We offer an ESPP (employee stock purchase program) and a 401K program which allows you to contribute typically within 30 days of starting, with a company match after 12 months of tenure. Apex also offers a HSA (Health Savings Account on the HDHP plan), a SupportLinc Employee Assistance Program (EAP) with up to 8 free counseling sessions, a corporate discount savings program and other discounts. In terms of professional development, Apex hosts an on-demand training program, provides access to certification prep and a library of technical and leadership courses/books/seminars once you have 6+ months of tenure, and certification discounts and other perks to associations that include CompTIA and IIBA. Apex has a dedicated customer service team for our Consultants that can address questions around benefits and other resources, as well as a certified Career Coach. You can access a full list of our benefits, programs, support teams and resources within our 'Welcome Packet' as well, which an Apex team member can provide.