Database Engineer

At the American Cancer Society, saving lives is our mission. We achieve our mission by drawing on our humanity. Humanity made up of courage, determination, innovation, passion, empathy, and caring. These are the values that give us the advantage over cancer.

Our work is important. And so are the people doing it. The people who work at the American Cancer Society focus their diverse talents on our singular mission: to end the pain and suffering of cancer. It is a calling. And the people who answer it are fulfilled. We value our employees and nearly 2.5 million volunteers around the globe that have stood with us through the years, and we will not rest until the fight is won. And that day is drawing nearer.

As the largest voluntary health organization, the American Cancer Society is passionately committed to saving lives from cancer. They are working to create a world with less cancer and more birthdays – a world where cancer never steals another year from anyone’s life. ACS combines relentless passion with the wisdom of nearly a century of experience to make this vision a reality, and they get results. ACS saves lives by helping people stay well, helping people get well, by finding cures, and fighting back. Thanks in part to this work; nearly 12 million cancer survivors and countless others who have avoided the disease will celebrate a birthday this year. The American Cancer Society is dedicated to hiring and retaining a diverse workforce to help achieve our mission.

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.

• Bachelor’s degree in Computer Science or related field of engineering, or equivalent combination of education and experience.
• 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.