REPORTS TO:VP OF IT SOLUTIONS
WORKS WITH:DATA HANDLING TEAMS IN THE ORGANIZATION
SUMMARY:
Database Developer are generally responsible for the performance, integrity and security of databases. They are often also involved in planning, developing and troubleshooting of databases.
The Database Administrator is responsible for the performance, integrity and security of database(s). They will also be involved in the planning, design, and development of the database(s); as well as troubleshooting any issues on behalf of the users. The goal is to provide a seamless flow of information throughout the organization, considering both backend data structures and frontend accessibility for end users. These responsibilities will include owning, tracking and resolving database related incidents and requests, fulfilling requests and resolving incidents within SLAs, reviewing service related reports (e.g.: database backups, maintenance, monitoring) on a daily basis to ensure service related issues are identified and resolved, responding to database related alerts and escalations and working with others in the Information Technology department to come up with strategic solutions to recurring problems.
ESSENTIAL JOB FUNCTIONS:
Designing database tables and structures.
Creating views, functions and stored procedures.
Writing optimized SQL queries for integration with other applications.
Creating database triggers for use in automation.
Maintaining data quality and overseeing database security.
Provide guidance and support to Application Developers
Assist with schema design, code review, SQL query tuning
Install, tune, implement and upgrade DBMS installations
Write and deploy SQL patches
Upgrade and improve application schema and data upgrades
Process work accurately and in a timely manner
Pay attention to detail at all times
Proactively and regularly make recommendations for system improvements
Collate, prepare and present statistical information for internal and external use
Responsible for troubleshooting and resolving database related performance problems and ensuring data integrity.
Implement operational automation using scripts.
Setup of archive and ETL jobs related to ongoing maintenance and optimization of all installed database systems.
Responsible for database architecture and documentation of Data Dictionaries and Relational Models.
Create database schemas, tables, fields, permissions, stored procedures and other elements in database systems.
Create and maintain database security, role-based group permissions, and data access.
Monitor systems and platforms for availability, proactively correcting related problems.
Work with project management and support teams on ensuring maximum performance and uptime of systems.
WORKING CONDITIONS:
While performing the duties of this job, the employee is regularly required to sit and talk or hear. The employee is frequently required to walk and use hands and fingers. The employee is occasionally required to stand and reach with hands and arms. The employee must occasionally lift and/or move up to 25 pounds.
Works in a normal office environment where there are few physical discomforts associated with changes in the weather or noise, dust, dirt and the like.
The incumbent’s working conditions are typically moderately quiet.
Create server and database sizing documentation needed for new projects or upgrades to existing systems.
Maintain professional and technical knowledge by attending educational workshops or training.
Contributes to team effort by accomplishing project or development related results as needed.
Establish an environment of high performance and continuous improvement that values learning, a commitment to quality, welcomes and encourages collaboration, and fosters both intra and inter-departmental dialogue and respect.
Model the type and level of behavior, professionalism and personal leadership that is in accordance with the values. of the organization.
Perform other related duties as required.
QUALIFICATIONS:
Education:
Bachelor’s degree in computer science or a related information technology field, or equivalent training and experience related to Microsoft SQL database development.
Experience:
The following need to be very specific to MS SQL and the .Net framework.
8+ years of proven Database Administration experience required
Experience with Microsoft SQL Server and Business Intelligence platform tools required
Experience with T-SQL coding, writing stored procedures, and maintaining database security required
Excellent knowledge of data backup, recovery, roles, replication, and clustering techniques required
Excellent technical problem-solving capability (primarily with software applications, network environments, servers, and operating systems) required
Knowledge of third-party DBA tools and applications (e.g. TOAD, Erwin, ER Studio) required
Experience with Database Administration for MSSQL Server required
Experience in Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools required
Experience with backups, restores, replications, and other recovery models required
Knowledge of High Availability (HA) and Disaster Recovery (DR) options for MSSQL Server required
Experience working with Microsoft Business Intelligence platform tools; namely SSAS, SSIS, and SSRS required
Experience working with Windows Azure or other cloud-based server platform technologies required
Knowledge of indexes, index management, and solving production issues based on statistics required.
4 years of experience with programming languages such PL/SQL coding
Easily design and implement a business process into functional and efficient code
Implement and manage Organization data management practices and policies
4 years of experience in administering, managing and tuning databases
4 years of experience with Oracle RAC, SQL Server or MySQL
Good understanding of data and scheme standards and concepts
Good understanding of database design, implementation, troubleshooting and maintenance
expertise in SQL
Sense of ownership and pride in your performance and its impact on organization success
Critical thinker and problem-solving skills
Good time-management skills
Licenses and Certifications:
MCTS, MCITP, MCSE, or MCDBA certifications preferred
KNOWLEDGE, SKILLS AND ABILITIES:
Computer Skills – Advanced skills using Microsoft Office products Word, Excel, PowerPoint and Outlook.
Customer Service - Manages difficult or emotional customer situations; Responds promptly to customer needs; Solicits customer feedback to improve service; Responds to requests for service and assistance; Meets commitments.
English Language — Knowledge of the structure and content of the English language including the meaning and spelling of words, rules of composition, and grammar.
Oral Communication - Speaks clearly, persuasively and professionally in positive or negative situations; Listens and gets clarification; Responds well to questions; Demonstrates group presentation skills; Participates in meetings.
Written Communication - Writes clearly and informatively; Edits work for spelling and grammar; Varies writing style to meet needs; Presents numerical data effectively; Able to read and interpret written information.
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 everyone's efforts to succeed.
Ethics - Treats people with respect; Keeps commitments; Inspires the trust of others; Works with integrity and ethically; Upholds organizational values.
Reasoning - Ability to apply common sense understanding to carry out instructions furnished in written, oral, or diagram form. Ability to deal with problems involving several concrete variables in standardized situations.
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.
