SummaryThe Database Engineer, Senior will work closely with the engineering team members to design, develop and enhance Microsoft SQL Server and PostgreSQL database solutions.
Duties and Responsibilities- Strong SQL, experience writing, tuning queries based on application requirements, performing debugging on database scripts and programs, and resolving conflicts.
- Highly skilled problem-solver and communicator that is fluent in most data manipulation languages.
- Design and code a high volume of SQL Queries, stored procedures, and SSIS packages
- Actively participate as part of matrixed product development teams providing advice on the design and tuning of database objects, queries, and overall data architecture.
- Use of tools and utilities to monitor, load, and unload data, generate, and edit test data
- Effectively plan and organize daily work following priorities, ensuring timely completion of projects and user support
- 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.
- Provide trend analysis to the service management team to make informed decisions regarding resource management.
- Develops a continually growing knowledge of the Company's internal business practices, processes, and the daily IT operational needs of the users
- Provide query and performance expertise in support of code development
- Monitor long-running transactions and optimize query executions with index tuning and optimized T-SQL coding technique
- Problem escalation to the development team and third parties as appropriate.
- Implementation and release of database changes as submitted by the development team
- Documenting technical environments and processes as necessary
- Participate in the on-call rotation
Qualifications & Requirements- In-depth SQL knowledge is required, including advanced tuning skills.
- Expertise in Microsoft SQL Server or PostgreSQL.
- Experience with clustering and log shipping.
- Strong communication skills and the ability to share ideas and work well in small teams.
- Possesses excellent problem-solving capabilities.
- Independent and self-motivated.
- Bachelor's degree in computer science, engineering, business, or the equivalent is preferred, and five plus years of database development experience is preferred.
- Experience with Microsoft SQL Server 2008 and SSIS is required.
- Knowledge of other programming languages is a plus.
Working ConditionsMust be able to perform essential job duties. Work is performed primarily in an office environment. Typically requires the ability to sit for extended periods (66%+ each work day), the ability to hear the telephone, the ability to enter data on a computer, and may also require the ability to lift to 10 pounds.
