Sr Database Engineer
Posted on: January 16, 2022
JOB SUMMARYDevelops large and complex databases through creation
of logical and physical models of data. Provides leadership through
demonstrated expertise in the design, implementation and
maintenance of production databases in compliance with application
specifications and company policies, standards and procedures.
Manages and maintains all production and non-production databases.
Demonstrates a mastery of a dedicated platform (Oracle, MSSQL,
etc.). Guides multiple projects as a functional expert. MAJOR
DUTIES AND RESPONSIBILTIES
- Actively and consistently supports all efforts to simplify and
enhance the customer experience.
- Provide leadership on the creation of physical and logical
database models according to the business requirements.
- Perform database engineering and administration tasks in ,
including design/modeling, SQL and script development, SQL and
database tuning, data migrations, backups and recoveries, software
installations and upgrades, and DBA support (including after-hours
when needed) for three-tier, client/server databases.
- Collaborate and guide multiple projects by understanding the
business requirements for designs, implementation and production
- Design, implement and maintain backup and recovery strategies
on Database Management Systems.
- Provide support for escalations of multiple services and
multiple databases of varying complexity with multiple concurrent
users, ensuring control, integrity and accessibility of data.
- Expert in setup using OEM as a monitoring and diagnostics tool
and identifies/resolves the performance issues.
- Provide escalated support in the troubleshooting of alerts
(alert log, Jobs, Disk Group, Tablespace etc.) and performance
- Perform capacity planning of MSSQL environment and provides
recommendations to management to sustain business growth.
- Expert in ETL tools and workflow creation, specifically
- Design, implement and maintain scheduled jobs to import data
from various external systems using ODBC, REST API, and SSIS
- Guide the creation of standard operational procedures and
templates.REQUIRED QUALIFICATIONSSkills/Abilities and Knowledge
Ability to read, write, speak and understand EnglishExpert
knowledge of T-SQL programming languageData modeling Database
performance tuning ODBC Expert knowledge of database architecture
and its implementationExpert understanding of best practices in
maintaining medium to large scale Oracle database systemsExpert
understanding of Change Management proceduresExpert knowledge of
Instance, database and query tuning to improve the performance of
the database/applicationExpert understanding of SAN technologies
related to SQL server disk layoutsExpert knowledge of
Windows/Linux/Solaris operating systems and shell scriptingAbility
to communicate orally and in writing in a clear and straightforward
mannerAbility to communicate with all levels of management and
company personnelAbility to handle multiple projects and
tasksAbility to make decisions and solve problems while working
under pressureAbility to prioritize and organize effectivelyAbility
to show judgment and initiative and to accomplish job dutiesAbility
to use personal computer and software applications (i.e. word
processing, spreadsheet, etc.)Ability to work independentlyAbility
to work with others to resolve problems, handle requests or
situationsAbility to effectively consult with department managers
and leadersComfort with having work peer-reviewed for accuracy and
design.EDUCATIONBA/BS in Information Technology, Computer Science,
MISRELATED WORK EXPERIENCE10+ years of experience working with
Oracle and various database management systems in engineering,
testing, implementation, maintenance and administration in a
multiple platform environment7+ years dedicated to a specific
platform (Oracle, MSSQL, etc.) demonstrated by mastery WORKING
CONDITIONS Office environment24x7 on-call support IDB310 301139
301139BR Here, employees don't just have jobs, they build careers.
That's why we believe in offering a comprehensive pay and benefits
package that rewards employees for their contributions to our
success, supports all aspects of their well-being, and delivers
real value at every stage of life.The pay for this position has a
minimum of $85,900.00. The actual salary offer may be higher as we
carefully consider a wide range of factors, including your skills,
qualifications, experience and location. Also, certain positions
are eligible for additional forms of compensation such as
Keywords: SPECTRUM, Denver , Sr Database Engineer, IT / Software / Systems , Denver, Colorado
Didn't find what you're looking for? Search again!