The Database Engineer will work as part of the Architecture and Data Management Team to build efficient and scalable database solutions for transactional applications as well as reporting and analysis. The DB Engineer will be a key contributor to the improvement of database systems by conducting routine performance analysis and applying optimization to database configurations or underlying SQL code, which will then be applied to the production system after load testing. The role will work with project teams to design and build application as well as analytic data models, build instances to house the physical databases, and implement stored procedures or integration services packages for transactional as well as bulk data movement. The DB Engineer will work with the Enterprise Data Architect as well as Application Architects in detailed design efforts, and will provide technical documentation of their work. The position demands that the DB Engineer constantly strives to be on the current edge of technical trends and practices with the intent of translating that knowledge into continuous database or process improvement. The role will have frequent opportunities to collaborate with many diverse individuals and teams looking to leverage everyone's unique skill sets that range from Business Analysts, Functional Designers, Solution Architects, and Service Layer Developers.
- Develop, implement and package database designs and updates for application releases
- Perform database and query performance reviews, and implementing changes
- Manage and support development and test databases
- Analyze current databases for performance opportunities
- Install, configure and upgrade Microsoft SQL Server, Teradata or Oracle software instances
- Develop and maintain documentation and development standards
- Implement performance optimizations through lower regions and package for deployment to production.
- Minimum of 4+ years in IT data-related fields including Database Administration, ETL Development, SQL Development or similar.
- Minimum of 4+ years working as a DBA or Database Engineer with focus on Microsoft SQL Server, Oracle RDBMS, Teradata, or some combination of all
- At minimum 3 years in PL/SQL or Transact-SQL
- Strong technical, analytic, and problem-solving skills
- At least 3 years with Oracle 10g+ or Microsoft SQL Server (versions 2005 and higher) SQL Development or Database Administration in Development or Test Environments
- Demonstrated experience creating SSIS packages
- Prior experience with configuration and change and release management using standard tools
- Existing experience in Unit and Integration testing as part of the project lifecycle
- Detailed knowledge of relational database administration systems in general
- Proven SQL Server Database, Teradata or Oracle Database query performance tuning ability
Demonstrates Information Technology Competencies:
- Business insight - Applies knowledge of business and the marketplace to advance the organization’s goals.
- Decision quality - Makes good and timely decisions that keep the organization moving forward.
- Action oriented - Takes on new opportunities and tough challenges with a sense of urgency, high energy, and enthusiasm.
- Optimizes work processes - Knows the most effective and efficient processes to get things done, with a focus on continuous improvement.
- Ensures accountability - Holds self and others accountable to meet commitments
- Collaborates - Builds partnerships and working collaboratively with others to meet shared objectives.
- Communicates effectively - Develops and delivers multi-mode communications that convey a clear understanding of the unique needs of different audiences.
- Instills trust - Gains the confidence and trust of others through honesty, integrity, and authenticity.
Other Skills:
- Ability to work well on multiple tasks simultaneously
- Must be strong self-starter able to work independently under limited supervision
- Strong interpersonal skills and the ability to work effectively with a wide range of constituencies in a diverse community
- Prior involvement with software projects using .NET for transaction processing
- Advanced knowledge of PL/SQL, Transact-SQL, data modeling, physical database design, and performance tuning.
- SSIS design/development in SQL Server 2012 a plus
- Prior knowledge of Siebel database structures a plus
- Prior experience with Teradata (v.13 and higher) a strong plus
We are committed to providing staff with fulfilling opportunities to learn, grow and make an impact in their local communities. We offer staff a generous paid time off policy; medical, dental and retirement benefits, and professional development programs to enhance staff skills.