PeoriaILRecruiter Since 2001
the smart solution for Peoria jobs

Staff Administrator, DBA

Company: Trinet
Location: Vermont
Posted on: November 17, 2021

Job Description:

TriNet is a leading provider of comprehensive human resources solutions for small to midsize businesses (SMBs). We enhance business productivity by enabling our clients to outsource their HR function to one strategic partner and allowing them to focus on operating and growing their core businesses. Our full-service HR solutions include features such as payroll processing, human capital consulting, employment law compliance and employee benefits, including health insurance, retirement plans and workers' compensation insurance. TriNet has a nationwide presence and an experienced executive team. Our stock is publicly traded on the NYSE under the ticker symbol TNET. If you're passionate about innovation and making an impact on the large SMB market, come join us as we power our clients' business success with extraordinary HR. JOB SUMMARY/OVERVIEW As a Staff Oracle Database Administrator, you will be part of a dynamic team that administers and runs complex database systems. You will create, manage and monitor mission critical databases that are core to the firm. You will be responsible for database administration on Oracle Exadata, on-prem and Cloud RDS engineered systems, solving complex performance problems, capacity planning and automation. You will have sophisticated knowledge in database and application (Oracle RAC and Golden Gate) technologies. Advanced ability to identify possible causes and solutions for problems based on prior experience and current research. You will weigh the costs, benefits, risks and chances for success before recommending a course of action. You must have experience with monitoring, problem diagnosis and resolution, installation and configuration with applications you support. Must have advanced knowledge in database (Oracle), application (Linux based) and performance tuning. Must ensure compliance with established industry rules, regulations and standard methodologies. Essential Duties and Responsibilities: * Ensures availability, security and integrity of assigned databases. * Resolves database performance, capacity, replication, and other distributed data issues. * Installs and configures database management software (DBMS) and applicable service packs and/or patches. * Develops and implements database maintenance plans, including performing integrity checks, updating statistics and monitoring security and hardware resource utilization. * Establishes regular backups of databases and archive logs. * Advanced knowledge of RAC and Data Guard. * Handles logins and user accounts, including assigning database object permissions and ancillary privileges. * Schedules and leads jobs for data transfers and sundry procedures and monitors performance and impact on operations. * Participates in data modeling and database logical and physical design. * Participates in application development processes and code reviews of database objects. * Analyzes long-term database performance trends to optimize database and application performance. * Configures database server to work with middleware, web servers and OnLine Analytical Processing (OLAP) tools. * Configures, supports, and optimizes replication. * Participate in deep architectural discussions to design purpose-built database solutions for successful deployment in the cloud * Build and coach the team on the skills needed to conduct one-to-few and one-to-many training sessions, so they can transfer deep technical skills * Demonstrable experience in establishing a solutions architecture practice and developing scaling mechanisms that can be used across an organization. * Knowledge of the underlying infrastructure requirements such as Networking, Storage, and Hardware Optimization. * Experience communicating and working with Developers, IT, Data/Technology/Product teams to articulate database strategies and plans. * Experience of data migration techniques and process planning including transaction processing, security, logging and monitoring. * Experience of sophisticated deployment architectures such as availability, resiliency and fault tolerance. * Deep understanding of AWS services related to databases helpful, particularly Amazon RDS, Amazon Aurora * Demonstrated effectiveness working across multiple business units to achieve results Qualifications and Skills: * Minimum of a bachelor's degree in Computer Science, MIS or related degree and Fourteen (14) years of relevant experience including database administration, database programming experience or combination of education, training and experience. * 8 to 10 years of experience with the following Oracle products and options: Oracle RDBMS Enterprise Edition, Real Application Clusters (RAC), Replication solutions such as Data Guard and Golden Gate, Exadata and other engineered systems, Multitenant, Oracle Enterprise Manager (OEM). * 10 years of experience as a hands-on Senior Oracle database administrator. * Experience in Oracle 19c, 18c, 12c, ASM, Appliance, database monitoring, and Linux OS. * Expert in RMAN backup/restore with optimization. * Experience in Exadata/Oracle patching procedures * Experience with PL/SQL code development and tuning. * Extensive experience in performance tuning and analysis using AWR, ASH, wait analysis. * Experience with automation and scripting skills using Perl, shell scripting, or Python a strong plus. * Capacity planning for all aspects of a database system (storage, compute, memory, etc.). * Understanding of networking and connectivity and how it relates to a database environment. * Experience in HR Services industry preferred. * Participates in application development processes and code reviews. * Experienced in RMAN backup and recovery process. * Analyzes long-term database performance trends to optimize database and application performance. * Ability to work non-standard shift including nights and/or weekend on-call responsibilities. * Strong ITIL principles a plus. * Serves as a technical liaison to partner with other Technology teams on enterprise initiatives. * Develop operational service metrics with measurable plans to improve efficiency, enhanced service, and optimized delivery times. * Provide leadership and recommendations on future state design and installation. * Provide after-hours support as required. * Develop scripts to automate administrative tasks. Training Requirements (licenses, programs, or certificates) Desired: * OCA/OCP * AWS WORK ENVIRONMENT/OTHER INFORMATION (Travel required, physical requirements, on-call schedules, etc.) * Minimal travel required * Work in clean, pleasant, and comfortable office setting * Required to participate in on call rotation The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. Please Note: TriNet reserves the right to change or modify job duties and assignments at any time. The above job description is not all encompassing. Position functions and qualifications may vary depending on business necessity. TriNet is an Equal Opportunity Employer and does not discriminate against applicants based on race, religion, color, disability, medical condition, legally protected genetic information, national origin, gender, sexual orientation, marital status, gender identity or expression, sex (including pregnancy, childbirth or related medical conditions), age, veteran status or other legally protected characteristics. Any applicant with a mental or physical disability who requires an accommodation during the application process should contact to request such an accommodation.

Keywords: Trinet, Peoria , Staff Administrator, DBA, Other , Vermont, Illinois

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category

Log In or Create An Account

Get the latest Illinois jobs by following @recnetIL on Twitter!

Peoria RSS job feeds