Database Developer

ESSENTIAL JOB FUNCTIONS: Include, but are not limited to, the following:

• Works with the infrastructure DBA to ensure the performance, availability, and security of the database.

• Writes and understands Microsoft SQL. Writing SQL statements, stored procedures and views using industry best practices for security and efficiency.

• Provides expert level support for reporting needs.

• Provides user support associated with development activities.

• Responsible for troubleshooting and problem solving of SQL development.

• Assists infrastructure DBA with routine performance and availability testing on database servers to ensure scalability, resiliency, and capacity of all applications.

• Provides expert level database administration support to 3rd party vendors, developers and others as needed.Works with implementation team to build, customize and roll out new solutions to organization and with consultants to design and build database structure specific to business needs.

• Remains competent and current through self directed professional reading and researching available tools and products, developing professional contacts with colleagues, attending professional development courses, and attending training and/or courses as assigned by the Senior Database Analyst.

• Contributes to the overall success of the IT Department by performing other duties and responsibilities as assigned.

SUPERVISORY RESPONSIBLITIES: Provides mentorship for Database Analysts and any other junior database IT team members.

QUALIFICATIONS: The requirements listed below are representative of the knowledge, skills, and/or abilities required to successfully perform the job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Knowledge, Skills and Abilities

• Advanced knowledge of SQL databases and replica-sets gained through running critical systems.

• Thorough understanding of Profiling, Performance Tuning and Optimization, using native monitoring and troubleshooting tools to resolve database problems.

• In-depth knowledge of SQL Server Database Administration including clustering.

• Strong proficiency of T-SQL coding, PowerShell coding and stored procedures.

• Exceptional knowledge of SQL Monitoring tool – IDERA.

• Implementation knowledge and ability with SQL Mirroring and log shipping.

• Knowledge of indexes, index management and statistics.

• Knowledge of MS SQL 2000/2005/2008 RDBMS on large systems helpful.

• Workable knowledge and familiarity with storage, hardware and network components used in database clustering.

• Knowledge of disaster recovery procedures.

• Highly analytical and an excellent problem solver with the ability to handle and prioritize multiple projects simultaneously with competing demands in an effective and productive manner, with a systematic approach to identifying issues.

• Methodical and accurate while delivering to deadlines.

• Good performance turning and troubleshooting skills critical..

• Knowledge of SQL 2012 – Always On to implement HA and DR solutions.

• Self motivated and self sufficient with ability to work under minimal supervision.

• Good communications skills with a good command of the English language.

• Good interpersonal and customer service attitude with the ability to maintain effective working relationships with all stakeholders; a good team player with the willingness to assist the team whenever necessary.

• Willingness to work evenings, weekends, holidays as required to provide support and maintenance for systems, and to ensure 24/7 support and troubleshooting of business-critical database servers.

• Knowledge of developing database objects for web and desktop applications.

• Must be willing to work “on call” regularly.

• Must be able to pass background investigations.

Education and/or Experience:

• Bachelor’s degree in Computer Science, Information Systems or other related technical discipline acquired through a regionally accredited institution.

• Minimum of three years’ related experience in working with databases preferably in a high-availability production environment; experience in higher education with online services preferred, including:

• Working knowledge of MS SQL Server databases’ installs

• BI/Data warehousing experience on Microsoft tools is helpful.

• Experience with Transactional SQL (T-SQL) and SSIS Packages.

• Practical experience in managing the internal and external and MS SQL database security, maintenance plans and disaster recovery.

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.

The following physical demands are estimated by the amount of time spent. Usually, the amount of time spent will be estimated on a daily basis, but depending on the position could be estimated on a weekly basis or a monthly basis.

Constantly: 60%+ or 5-8 hrs/shift            Occasionally: 10%-25% or 1-2 hrs/shift

Frequently: 25%-60% or 4-5 hrs/shift     Rarely: less than 10% or less than 2 hrs/shift

• Work is characterized as more than 50% sedentary at a desk.Work and tasks constantly involve the use of a computer, monitor, keyboard and mouse or mouse pad and/or mobile device.

• Constantly uses hands, fingers, wrists, forearms, shoulders, neck while using a QWERTY keyboard, mouse or mouse pad or other pointing technology.

• Constantly uses close-up vision to view, read, observe, review, compare, identify, interpret, research, report, sort, revise, analyze, select data and data elements on monitors and/or technical manuals or hard-copy.

• Work involves frequent communications to relay information, recommendations, suggestions, interpretations of data, and/or instructions to or with users, management, staff, team members using a variety of means such as telephone, one-on-one and group meetings, web conferencing, mobile device (texting/IMing) and other means as available with technology.

• Work rarely involves the ability to move about the office or move about the campus or other GCU facilities.

• Work rarely involves lifting, moving or carrying items heavier than 50 pounds, climbing, reaching, kneeling, stooping, bending, pushing, pulling.

• Work constantly involves mental acuity requiring planning and organizational skills, spatial recognition and placement skills, decoding information, using critical thinking skills to determine logical sequences and paths for processes, language comprehension, and to formulate sound conclusions, and extended periods of concentration/focus on the task at hand;

• Work constantly involves synthetic thinking for prioritizing and monitoring work, tasks and activities in a logical manner and meeting deadlines and project timelines; accuracy and thoroughness; solving complex issues and problems; using creativity for problem solving and formulating logical recommendations.

• Work frequently involves the ability to translate and interpret complex technical information and restate it in simplified terms.