Overview
On Site
$116000 - $146000 yr
Full Time
Skills
ORACLE
19C
BUSINESS SUITE
Job Details
Integrated Talent Strategies is seeking a Senior Database Engineer for a client based in Cleveland, Ohio. This is a hybrid role base in Cleveland Ohio with a large Fortune 500 company. This role will provide a 6% 401k match, an employee pension, and fantastic healthcare benefits in addition to base salary.
#LI-RS1
The Senior Database Engineer role designs and develops robust and reliable database management systems that are secure, reliable, meet the organization's needs. They will develop technical platforms using modern tooling, build systems and processes for operations and maintenance that facilitate production needs and speed application development. By doing so, they bring significant value to the organization by ensuring that business operations run smoothly and efficiently, and change can be efficiently performed and managed. The incumbent works collaboratively with cross-functional teams that include developers, data analysts, data scientists, business analysts, and other relevant stakeholders within the organization.
#LI-RS1
The Senior Database Engineer role designs and develops robust and reliable database management systems that are secure, reliable, meet the organization's needs. They will develop technical platforms using modern tooling, build systems and processes for operations and maintenance that facilitate production needs and speed application development. By doing so, they bring significant value to the organization by ensuring that business operations run smoothly and efficiently, and change can be efficiently performed and managed. The incumbent works collaboratively with cross-functional teams that include developers, data analysts, data scientists, business analysts, and other relevant stakeholders within the organization.
Responsibilities
WHAT THE ROLE WILL DO:
- Design and develop database management systems, standards, guidelines and quality assurance for database deliverables.
- Patch and maintain database systems for optimal security and supportability
- Document and communicate database designs to relevant stakeholders and analyze the impact of the data architecture
- Code complex programs and develop logical processes on technical platforms.
- Participate in quality assurance by developing and testing database code in client server environments.
- Adapt business requirements and develop data, database specifications, and table and element attributes for applications.
- Develop an understanding of the organization's data and storage mechanisms and assist with capacity planning.
- Determine appropriateness of data for storage and optimum storage organization.
- Determine how tables relate to each other and how fields interact within the tables for a relational model.
- Work with stakeholder to define the database Disaster Recover plan, database back-up, recovery and archiving strategy
Qualifications
Education
- Required
- Bachelor's degree in Computer Science, Statistics, or Information Systems or in lieu of a degree, at least 7 years of experience in the field of database engineering and administration
Skills and Experience
- 4-6 years of experience in database engineering and administration
- Knowledge and experience with database design, implementation, documentation, and management
- In-depth understanding of database management systems and data structures
- Experience translating business data needs into technical language
- Ability to deal with large pool of data often unstructured coming from disparate sources
- Experience with relational databases [such as Oracle, DB2, Postgres, MySQL, or Microsoft SQL Server]
- Experience with query and coding languages [such as SQL, PL/SQL, Python]
- Knowledge and experience in database performance tuning, backup and recovery strategies, and data security practices
Preferred
- 5+ years of experience developing OLTP database applications in Oracle 19c and UNIX/LINUX/Solaris environment within a multi-tier environment; building and formulating business requirements.
- Work experience with PL/SQL Types, PL/SQL Collections, SQL Loader, PL/SQL Functions and Procedures, Packages, and Materialized view, Triggers, Complex SQLs, and SQL Reports.
- Work experience with PL/SQL techniques in LOBs, Multilingual character conversion; Optimize the applications using Exadata Oracle Performance Tuning Techniques; develop Unit Testing Methods for PL/SQL; develop UNIX scripts for batch processing and work with Oracle RAC clusters and Exadata systems.
- Experience with relational SQL and NoSQL databases. Build processes supporting data transformation, data structures, metadata, dependency, and workload management.
- Experience building and optimizing data pipelines, architectures, and data sets.
- Experience in cloud databases.
- Proficiency in data modeling software like ER diagramming tools, database design tools, and data modeling languages.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.