PTC-posted 13 days ago
Full-time • Mid Level
Hybrid • Boston, MA

Design, maintain, and control a variety of databases in a federally secure datacenter. Primarily manage Oracle databases but also Postgres and MSSQL. The position will provide 24X7 operational support for databases which run internally developed applications. Such applications are revenue generating under stringent SLAs. The position will work closely with Application Delivery, Infrastructure- Systems and Networking and Technical Support, in support of the databases/application. In addition to operational DBA tasks, the position will work closely with the Security team for annual audits for compliance. Maintains the operations of a mixed Oracle database environment- single, RAC and DG, multi-tenant instances. Maintains the operations of single Postgres and MSSQL databases Perform regular maintenance of the databases including backups and restores and review of logs for errors or potential problems. Regularly review space capacity and perform tasks to manage space usage through archiving or increasing disk space Collaborate with other operational Oracle DBAs, developers, infrastructure teams and external customers to resolve problems with application/database systems. Installation, Configuration, Upgrading and Patching of databases and related products Develop and implement archiving, backup and recovery strategies Ability to complete tasks and produce appropriate deliverables within project time schedules Responsible for database monitoring, troubleshooting Configuration, backup/recovery, sizing, space management, diagnostics, and proficient with the use of Oracle's Enterprise Manager/ Cloud Control. Designs, implements, and periodically tests the database backup and recovery procedure in conjunction with other IT staff. Team player with excellent written and oral communication and organizational skills Demonstrate willingness to learn new skills, cross train on a large number of systems and provide knowledge transfer to other team members On call schedule participation and provide 24X7 Support Off hours patching support Manage cases in ticketing system

  • Design, maintain, and control a variety of databases
  • Provide 24X7 operational support for databases
  • Work closely with Application Delivery, Infrastructure- Systems and Networking and Technical Support
  • Work closely with the Security team for annual audits for compliance
  • Maintain the operations of a mixed Oracle database environment- single, RAC and DG, multi-tenant instances
  • Maintain the operations of single Postgres and MSSQL databases
  • Perform regular maintenance of the databases including backups and restores and review of logs for errors or potential problems
  • Regularly review space capacity and perform tasks to manage space usage through archiving or increasing disk space
  • Collaborate with other operational Oracle DBAs, developers, infrastructure teams and external customers to resolve problems with application/database systems
  • Installation, Configuration, Upgrading and Patching of databases and related products
  • Develop and implement archiving, backup and recovery strategies
  • Complete tasks and produce appropriate deliverables within project time schedules
  • Responsible for database monitoring, troubleshooting Configuration, backup/recovery, sizing, space management, diagnostics, and proficient with the use of Oracle's Enterprise Manager/ Cloud Control
  • Design, implement, and periodically test the database backup and recovery procedure in conjunction with other IT staff
  • Participate in on call schedule and provide 24X7 Support
  • Provide off hours patching support
  • Manage cases in ticketing system
  • 4+ years as an Oracle Database Administrator
  • B.S. degree in computer science or equivalent.
  • Oracle - OCP or equivalent certification
  • Experience with Oracle ASM/GRID/RAC - 19c, 26ai (exposure)
  • Experience with managing multiple RDBMS on large systems, preferably high availability 24x7 environments in both on-premise data centers and Cloud environments (AWS, Azure, OCI)
  • Experience installing, patching, upgrading and maintaining Oracle database
  • Experience with configuration, backup/recovery, sizing, space management, PL/SQL tuning, diagnostics, and proficient with the use of Oracle's Enterprise Manager/Cloud Control.
  • Experience planning, configuring, and replicating Oracle DataGuard, or similar Disaster Recovery solution.
  • Experience with DataPump, RMAN & restore and recoveries across various scenarios
  • Hands on experience with advanced Oracle features like partitioning, parallelized queries and other Oracle EE features.
  • Prior experience with performance analysis, performance tuning and with debugging, identifying and fixing performance issues.
  • Experience with SQL Server 2019/2022 for performance and tuning and backup/restore
  • Strong verbal, written and interpersonal communication skills
  • Ability to manage responsibilities as a hybrid employee.
  • Experience with Linux and Windows environment
  • Demonstrates excellent communication, organizational and follow up skills.
  • Must have or be able to obtain a Secret Security Clearance
  • US citizen requirement
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service