- Recommend the procurement of new memory, CPUs, and servers when necessary.
- Research, analyze, and determine appropriate changes to RDBMS parameters to support future applications and database needs.
- Measuring current capacity, gauging the growth of capacity over time, and factoring in the anticipated capacity requirements to determine wither the existing infrastructure can sustain the anticipated workload.
Senior Oracle Database Administrator - Lansing, United States - Tekwissen
Description
Overview:
Tekwissen Group is a workforce management provider throughout the USA and many other countries in the world. The below Client runs through fifteen executive departments which carry out the day-to-day administration of the federal government. Popular departments like Agriculture and Rural Development, Civil Rights, Environment, Health and Human Services, Natural Resources, Secretary of State.
This Client has opportunities in a number of career pathways, including, but not limited to, business and administrative support, education and human services, IT and computers, medical and healthcare, natural resources, law enforcement and public safety, skilled trades and more.
With positions in over 18 state departments, your perfect career fit is waiting for you at the client. This client is an Equal Opportunity Employer.Job Title:
Senior Oracle Database Administrator
Location:
Lansing, MI, 48915
Duration: 12 Months
Job Type:
Hybrid
Work Type:
Contract
Job Description:
General Summary of Function/Purpose of Position:
As a senior Database & Services Administrator, the employee performs a complete range of information system database analyst assignments including, but not limited to, designing, developing, testing, and implementing database and related systems services for production, test, and development environments for LARA applications.
A senior Database Administrator plans, coordinates, and implements a full range of professional database & services administration functions for LARA as part of the database services team.
Provides analytical and technical support and leadership around specialized software for database systems, developing database structures for applications, and related services such as job scheduling/automation & print/document management.
This position is also responsible for the support and maintenance of numerous databases and services.
Responsible for the design, installation, and implementation of physical and virtual databases.
Proactively monitor, write complex scripts, do performance tuning, and troubleshooting for an environment that requires a higher support level.
This position will assist technical staff in researching about patches/upgrades, identification/troubleshooting, and resolution of database issues, and work with database security & compression tools.
It is also responsible for assisting the planning, design, and implementation of security measures/tools which safeguard access to database files and data elements.
Oracle Database Administration (19c or higher)
RAC (required)
OEM
Perform Patching and Updates
Vulnerability Remediation
Desired Skillset:
OEM- setting up alerts, metric extensions, and other capabilities we can leverage
Data masking - Utilizing
OEMor other solutions
Experience with RAC and zero downtime patching
Experience with patching - GIRU, DBRU, OJVM, JRE
Ability to follow directions and communicate effectively
MS Outlook (ability to schedule MS TEAMs meetings, calendaring of implementations, etc.)
Documentation of processes and procedures (read, comprehend, create)
Linux, vi, MobaXterm (preferred)
Performance tuning, partitioning, advanced compression
TOAD and SQL Developer; other tools
Azure DevOps (preferred) or other ticketing system(s)
Vulnerability Remediation (Tenable experience preferred)
Ability to meet deadlines under tight time constraints
Duties of the position:
As a senior level information technology programmer/analyst, uses advanced principles and procedures of systems design methodology, structured systems design, and automated data processing techniques for new and existing complex computer applications.
Coordinate with vendor support to address technical issues that could not be resolved in-house.
Participate in the planning process to match emerging technologies with future business needs.
Establish standards and guidelines for database space allocation based on best practices and implementation considerations based on business requirements.
Calculate disk space requirements for existing and/or new installations and growth based on changing business requirements.
Measure and/or forecast current capacity, gauge the growth of capacity over time, and factor in the anticipated capacity requirements to determine whether the existing infrastructure can sustain the anticipated workload.
Research, analyse, and determine appropriate hardware changes to support future application and database needs. Report recommendations to appropriate DBA specialist and/or technical services.
Review results of database integrity checks. Resolve identified issues.
Design appropriate strategy to reorganize database objects to release unused space or repair fragmentation.
Install database management software in any environment
Install database patches and service packs in any environment.
Provide maintenance, support, and assistance to specialist DBAs with installation and configuration of clustered database failover, database replication solutions, and database backup solutions.
Review, install, analyse, and implement security patches to be applied to remain Payment Cared Industry (PCI) compliant, vendor compliant, and client Cyber Security compliant.
Define/design roles and profiles.
Recommend standard password security policies.
Implement data encryption.
Design, configure, and initiate auditing with appropriate options as needed.
Create and deploy new database in development and test environments.
Ensures and validates the integrity and quality of the scripts to be promoted to any of the environments.
Provide guidance to systems analysts, based on documented standards, in creating and modifying application specific database objects.
Perform Data Export/Import/Load and data transformations between databases in production environments.
Perform production data file transfers between different systems, across state agencies, federal government, vendors, etc.
Analyse and resolve database space utilization in production environments.
Analyse and resolve issues with database integrity in development, test, and production environments.
Design and implement database backup solutions based on the business needs which include configuration, testing, implementation, modification, automation and monitoring of the backup and recovery solution as needed; troubleshoot and resolve more complex backup issues.
Perform database restorations and point in time recovery to avoid data loss and meet service levels objectives.
Perform troubleshooting of performance issues and provide required solution.
Analyse databases for optimal performance and investigate poorly performing SQL statements and offending database sessions.
Perform database performance tuning by identifying index candidates, updating database statistics, using appropriate optimization techniques, optimizer hints and other methods.
Perform thorough analysis and investigation to resolve locking conflicts.
(For example:
Locking conflicts can be shared or exclusive.
Shared involve multiple users accessing the data or table at the same time. Exclusive is when only one user or process can access the data at a time.
Locking conflicts can also be at different levels and an incorrect resolution can cause corruption or loss of data.)
Analyse and resolve issues related to undo/redo/transaction log configuration and sizing in development, test, and production environments.
Analyse and resolve server generated and threshold-based alerts. Perform resolution for the alert causes and provide recommendations for setting up appropriate alert thresholds.
Implement defined initialization parameters, database instance memory structures and physical data layout for optimal performances.
Monitor database jobs and scheduled processes, perform troubleshooting and provide resolution for any issues with jobs/processes as necessary.
Document solution and provide root cause analysis.
Agrees to follow all policy, standards, and procedures of DTMB.
Database Storage and Capacity Planning:
Monitor current space usage and contention. Perform capacity planning for future expansions of current application data and new applications needs.
Calculate disk space requirements for existing and/or new installations and growth of complex databases (i.e., multiple databases, multiple servers).
Database Security:
Ensure that appropriate environment and database management system security settings are in place to prevent unauthorized access, loss, or damage to data.
#J-18808-Ljbffr