Proficiency with creating CI/CD pipelines and stages with Harness using YAML templates. Kong plugin development using Lua or Go. Experience with Package Managers like LuaRocks. Experience with containerization (Docker), and orchestration tools (Kubernetes). Experience with cloud platforms such as AWS, Google Cloud, or Azure. Familiarity with monitoring and logging tools like Datadog and OpenTelemetry.
Sr. Oracle Database Administrator
Location
United States
Posted
3 days ago
Salary
$45 - $50 / hour
Seniority
Senior
No structured requirement data.
Job Description
Sr. Oracle Database Administrator
Texas State Library and Archives Commision
Role Description - Provide Oracle Database Admin services to production, in-house testing, proof of concept. - Install, configure and maintain Oracle Enterprise Manager 12c/13c Cloud control. - Installation, DB Planning, Database Design and Development using ORACLE database versions 12c/11g. - Setup database high availability by installing/upgrading Oracle Cluster ware 11g/12c. - Plan, document and execute Disaster Recovery procedures. - Setup Backup methods for High availability of database and minimal Downtime and complete recovery of data. - Clone/Refresh non-production databases from production. Setup automation to refresh data between PROD and UAT. - Configure and maintain Active Data Guard. - Lead the DBA team to support on a 24x7 basis. - Identify and resolve performance issues in RAC, Non-RAC databases. Analyze AWR, trace files to resolve performance issues. - Index maintenance by creating, rebuilding them. Detecting Row Chaining and resolving using segment space advisor. - Evaluating Performance of SQL statements and PL/SQL modules by EXPLAIN PLAN, SQL TRACE, TKPROF OS utility, SQL * PLUS AUTOTRACE. - Applying CPU/PSU/interim patches. - Partition management like splitting, adding, moving, converting non-partitioned tables to partitioned tables, setup automated jobs to archive data from LIVE to ARCHIVE. - Migration of databases from on-premise to cloud platform. - SQL, PL/SQL scripting to create Database Triggers, Stored Procedures, Stored Functions, packages. - Create and maintain Unix shell scripts for day-to-day activities. - Setting of scheduled jobs in the database, on the server and in Oracle Enterprise Manager. - Install, upgrade and support Oracle APEX. - Install and configure Web logic Server, BI Publisher cluster. - Support Mid-tier tools like Oracle HTTP Server, Oracle Web Cache, Web logic and BI Publisher. - Handle Data Centre migration by migrating/moving the databases, applications. - Setup cloud infrastructure like EC2 Servers, S3 buckets, Oracle RDS databases for applications. - Design, develop and implement database, ETL related modules to setup data warehouse. - Setup and maintain Database Migration Service on cloud platforms like Amazon Web Services. - Handle heterogeneous database migration involving databases like Oracle, SQL Server, Postgres etc. - Work with vendors like Oracle, Rack space, Amazon on getting resolutions to the day-to-day issues. - Provide support to developers in code migration and releases. - Train and provide guidance for Junior Database Administrators and Database Administrators. Qualifications - Knowledge of database implementation in cloud and interfacing with applications in cloud. - Experience and knowledge in migrating code, database changes, data and menus through the various stages of the development life cycle. - Sound knowledge of both database and program code performance tuning. - A good knowledge of the operating system(s). - A good knowledge of physical database design. - A good knowledge of Oracle backup and recovery scenarios. - Skills involving all Oracle tools and processes. - Analytical thinking skills. - Problem solving. - Technical Expertise. - 0-3 years of relevant experience.
Related Guides
Related Categories
Related Job Pages
More Database Administrator Jobs
• Monitoring and Support for Analytical Data Platforms: Perform installation, monitoring, configuration and operational support of Big Data/Data Warehouse platforms (such as Teradata Vantage) and corporate databases of the Central Bank of Brazil. • Execution of Routines and Permissions Management in DBMS: Execute queries and DML/DDL commands not controlled by automated models, create access credentials, maintain scripts, and grant or revoke database permissions. • Performance Analysis and Diagnosis: Investigate and diagnose errors, failures or slowdowns in applications that access the databases, handle support tickets and provide support to the solution infrastructure.
Role Description The MEP VDC Fabrication Database Coordinator is a client-facing technical specialist responsible for developing, maintaining, and supporting Autodesk Fabrication databases and content for MEP and specialty trade contractors. This role involves: - Working closely with client VDC teams, BIM managers, detailers, estimators, fabrication personnel, and project stakeholders. - Creating and managing ITM content. - Configuring and improving fabrication databases. - Troubleshooting technical issues. - Performing quality assurance testing. - Maintaining clear documentation. The ideal candidate combines hands-on Autodesk Fabrication expertise with strong problem-solving, organizational, and communication skills to deliver reliable, standardized, and scalable database solutions that support client-approved fabrication workflows and business objectives. Qualifications - 3+ years of experience with Autodesk Fabrication content, databases, or MEP fabrication workflows. - Hands-on experience creating, modifying, testing, and supporting Autodesk Fabrication ITM parts. - Proficiency with one or more Autodesk Fabrication products, including CADmep, CAMduct, ESTmep, or Revit Fabrication Parts. - Working knowledge of Autodesk Fabrication databases, services, specifications, materials, connectors, and related content configurations. - Understanding of MEP systems and construction workflows, including HVAC, piping, plumbing, electrical, or specialty trades. - Experience interpreting manufacturer documentation, product specifications, fabrication standards, and technical drawings. - Strong troubleshooting, quality assurance, and problem-solving skills. - Excellent communication, documentation, organization, and client-service skills. - Ability to manage multiple priorities while working independently and collaboratively in a team environment. - Strong attention to detail and commitment to delivering accurate, maintainable solutions. Requirements - 5+ years supporting MEP contractors, fabrication shops, detailing departments, or VDC teams. - Experience managing multiple Autodesk Fabrication databases across clients or business units. - Experience with both sheet metal and piping fabrication content. - Experience integrating Autodesk Fabrication databases with Revit fabrication workflows. - Familiarity with Design Line, spooling, estimating, CAM output, fabrication, and installation workflows. - Experience with database migrations, software upgrades, content standardization, and configuration deployment. - Knowledge of BIM coordination, database governance, version control, and quality management practices. - Experience providing client training, technical support, mentoring, or consulting services. - Autodesk certifications or related BIM, VDC, fabrication, or trade credentials. Benefits - Generous and flexible time off (FTO), plus eight paid holidays. - Company-sponsored benefits include: - Group health insurance with nominal employee contribution. - Employer-paid short- and long-term disability coverage. - Access to optional benefits through a cafeteria plan, including dental, vision, life insurance, wellness reimbursement program, and other supplemental benefits. - Employer match of employee HSA contributions, dollar-for-dollar up to the IRS limit. - 401(k) with company match of up to 4% of base salary. - *Our company is currently unable to sponsor work visas. Candidates must be legally authorized to work in the United States without sponsorship. - Symetri is an Equal Opportunity Employer as to all protected groups, including protected veterans and individuals with disabilities.
• Designs, Installs, maintains and controls the organization's production and non-production databases. • Provides on-call support for production environments. • Plays a key role in ensuring the availability, performance and security of the databases.
• Working with Business Analysts on database design changes needed per requirements • Creating logical and physical data models from user requirements • Providing database support for development and deployment of database scripts in Development and Test environments. • Works in conjunction with other teams in the database administration of the Pre-Production and Production environments • Creating scripts for tables and other objects like triggers and procedures is our day-to-day • Performing data migrations • Maintaining data standards, including adherence to the Data Protection Act • Communicating regularly with technical, applications, and operational staff to ensure database integrity and security • Assisting customers with issues related to applications involving issues with PL/SQL code, UNIX shell scripts, cron job code running in development and production environments • Developing Oracle stored procedures, packages, functions, and triggers in support of new applications being deployed • Recommending solutions by defining database physical structure and functional capabilities, database security, data back-up, and recovery specifications • Implementing new releases and completing maintenance requirements • Monitoring performance and managing parameters to provide fast query responses to front-end users • Ensuring that storage, archiving, back-up and recovery procedures are functioning correctly • Support for writing database documentation, including data standards, procedures and definitions for the data dictionary (metadata) • Ability to support the updating of Security Artifacts and environment Vulnerability Analysis • Controlling access permissions and privileges


