DBA III

Position Summary: As a DBA, you will work with engineering and operations to support, maintain and improve our data integrity for our internal and external reporting solutions.

You’ll be responsible for managing the day-to-day data and system maintenance and ensuring that all reporting systems are stable and providing the correct information. Candidates should have clear ability to trouble shoot issues as well as demonstrate effective communication.

Duties and Responsibilities:

• Manage the development of a data ecosystem in collaboration with a team of software developers and IT business partners
• Perform testing and analysis of the system to provide options for improvement and developing next generation reporting.
• Participate in Agile development including, backlog grooming, stand ups, retrospectives, and sprint review in coordination with the development team to ensure a robust, quality user experience
• Manage ETLs that ingest vast amounts of data
• Maintain data integrity, table / view structures and queries
• Participate and learn the latest technologies and best practices in Data Engineering and be able to identify software solutions that can solve pain points in data management
• Apply value-driven designs to the development of ecosystem
• Collaborate with colleagues across the organization to make data, including raw and cleansed data, available for reporting as required

Education and Work Experience:

• Bachelor's degree or equivalent in IT, computer science or related field is a plus, with a minimum of 5-7 years of directly related work experience in one of these fields (additional work experience may be used to in place of degree)
• Knowledge of Agile/Scrum methodologies
• Solid communication skills for documenting complex processes and oral communication skills in communicating with technical and non-technical employees
• Strong diagnostic and data forensic skills in dealing with complex data situations.
• Excellent understanding of MS SQL programming SSRS/SSIS/SP/cursors/triggers, entity relationships, stored procedures, SSIS, SSRS, ETL, performance / query optimization, domain driven design, modeling patterns,
• Develop, implement, and optimize stored procedures and functions using SQL
• Review and interpret ongoing business report requirements.
• Develop procedures and scripts for data migration.
• Research required data Analyze existing SQL queries for performance improvements.
• An ongoing thirst for knowledge and ideas, and a passion for creating an amazing customer experience
• Provide and receive mentoring and training with other team members
• Creative problem-solving, proficient troubleshooting and profiling
• Promote education and knowledge transfer for design patterns, technical best practices, and relevant technologies and tools

Knowledge and Skills :

To perform the job successfully, an individual should demonstrate the following competencies to perform the essential functions of this position.

• Must maintain highest level of Confidentiality at all times.
• Ability to communicate effectively (verbal and written)
• Excellent interpersonal skills
• Proficient computer skills: must have working knowledge of Excel and Word,
• Ability to multi-task, follow up, and meet deadlines
• Strong attention to detail
• Ability to identify discrepancies and take initiative to research variances and correct
• Certifications are a plus
• Business mindset with strong technical skills
• Data / system certifications are a plus
• Business mindset with strong technical skills
• Firm sense of accountability and ownership for the data and systems with a demonstrated ability to drive development
• Proven track record of maintaining data systems and adhering to, updating and creating product requirement documents

Hours Required: 40 hours a week, occasional evenings and weekends may be required

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 frequently required to talk or hear, sit, use hands to finger, handle, or feel objects, tools, or controls; reach with hands and arms; and occasionally required to stand; walk; climb stairs.  The employee must occasionally lift and/or move up to 20 pounds.  Specific vision abilities required by the job include close vision and the ability to adjust focus.

Work Environment:

Work environment characteristics 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 usual environment is in a business office with a noise level in the work environment that is usually moderate. 

This is an exempt position.

This job description reflects management's assignment of essential functions, and may be subject to change at any time due to reasonable accommodation or other reasons.