What are the responsibilities and job description for the Database Engineer position at JBA International?
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:
Competencies:
Qualifications & Requirements:
Duties & Responsibilities:
- Strong SQL, experience writing, tuning queries based on application requirements and performing debugging on database scripts and programs, as well as 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 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 enable them to make informed decisions regarding resource management.
- Develops a continually growing knowledge of 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 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
Competencies:
- Perform all work and activities with honesty and integrity.
- Take personal responsibility for productivity, quality and timeliness of work.
- Effectively communicate (and listen) clearly, professionally, politely and persuasively in all situations; respond well and in a reasonable, timely manner.
- Challenge conventional practices and use creativity and information to lead, innovate, problem solve, and implement ideas to contribute to the growth of the organization.
- Support and meet company/department goals and core values.
- Collaborate with co-workers to achieve common goals.
- Problem Solving/Analysis.
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 5 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.