Database Engineer

Job Summary: The Database Engineer, Senior will work closely with the engineering team members to design, develop and enhance Microsoft SQL Server and PostgreSQL database solutions.

Duties & Responsibilities:

1. Strong SQL, experience writing, tuning queries based on application requirements and performing debugging on database scripts and programs, as well as resolving conflicts.
2. Highly skilled problem-solver and communicator that is fluent in most data manipulation languages.
3. Design and code a high volume of SQL Queries, stored procedures, and SSIS packages.
4. Actively participate as part of matrixed product development teams providing advice on design and tuning of database objects, queries, and overall data architecture.
5. Use of tools and utilities to monitor, load and unload data, generate, and edit test data.
6. Effectively plan and organize daily work following priorities, ensuring timely completion of projects and user support.
7. Work with the different Technology and business team members to ensure that the associated compute resources are allocated to the databases and to ensure high availability and optimum performance.
8. Provide trend analysis to the service management team to enable them to make informed decisions regarding resource management.
9. Develop a continually growing knowledge of Company's internal business practices, processes and the daily IT operational needs of the users.
10. Provide query and performance expertise in support of code development.
11. Monitor long running transactions and optimize query executions with index tuning and optimized T-SQL coding technique.
12. Problem escalation to development team and third parties as appropriate.
13. Implementation and release of database changes as submitted by the development team.
14. Documenting technical environments and processes as necessary.
15. Participate in the on-call rotation.

Competencies:

1. Perform all work and activities with honesty and integrity.
2. Take personal responsibility for productivity, quality and timeliness of work.
3. Effectively communicate (and listen) clearly, professionally, politely and persuasively in all situations; respond well and in a reasonable, timely manner.
4. Challenge conventional practices and use creativity and information to lead, innovate, problem solve, and implement ideas to contribute to the growth of the organization.
5. Support and meet company/department goals and core values.
6. Collaborate with co-workers to achieve common goals.
7. Problem Solving/Analysis.

Qualifications & Requirements:

1. In-depth SQL knowledge is required, including advanced tuning skills.
2. Expertise in Microsoft SQL Server or PostgreSQL.
3. Experience with clustering and log shipping.
4. Strong communication skills and the ability to share ideas and work well in small teams.
5. Possesses excellent problem-solving capabilities.
6. Independent and self-motivated.
7. Bachelor's degree in computer science, engineering, business, or the equivalent is preferred and 5 plus years of database development experience is preferred.
8. Experience with Microsoft SQL Server 2008 and SSIS is required.
9. Knowledge of other programming languages is a plus.