Previous Job
Previous
Oracle Database Administrator
Ref No.: 17-01717
Location: Boston, Massachusetts
The Senior Oracle Database Administrator is responsible for planning, implementing, managing, securing and documenting databases utilized by our client.

Environment:
  • Our current environment consists of Oracle databases (10g and 11g) operating on LINUX and AIX platforms.
  • We are a 24 X 7 support group and the Database Administrator will have some on-call / off-hours duties
  • Assignments include working with end users, applications development staff, system administrators, management, vendors, and staff from other organizations to ensure successful implementation and operation of our application systems.
Job Duties:
  • Install, implement and maintain relational databases, including doing RDBMS software upgrades as required.
  • Should be able to configure and maintain RAC databases
  • Setup RMAN backup and restore procedures.
  • Should able to test and implement latest Oracle feature in current environment.
  • Comply with standards, policies, and procedures for database design, implementation, maintenance and documentation
  • Conduct technical knowledge transfer session to other team members on new features.
  • Performance monitoring and tuning, capacity planning, problem diagnosis/ analysis and correction, and participate in tests for all phases of the application life cycle from proof of concept and initial development through production implementation and operations.
  • Comply with data security best practices and implement Oracle advanced encryption methods as necessary.
  • Provide strategic consulting and operations support for data security technology and process implementations.
  • Provide database security architectural guidance to align security services and technologies to best meet the objectives.
  • Monitor data growth and re-organize the table structures in separate table spaces.
  • Developing appropriate support structure – indexes, partitions
  • Develop database code as required to run as AIX / Linux scripts, SQL, and PL/SQL
  • Additional activities may include training of other staff, ensuring compliance with and assisting in the design, architecture for the new solutions and extensions, development of standards, policies and procedures.
Experience required:
  • 5+ years ORACLE DBA and hands-on database architecture experience
  • 3+ years of experience with Data Encryption solutions (Database, NAS/Server File System, Data Transmission etc.)
  • In depth knowledge of Oracle security best practices
  • Comprehensive understanding of Data Encryption methodology and solutions
  • Security and compliance experience including Encryption, Audit, Authentication, PCI, GLBA, SOX, etc.
  • Architectural and operational understanding of Database Middleware, Virtualization, and Firewall solutions
  • Experience writing and reviewing technical design solutions
  • Hands-on experience with configuring and supporting Oracle in high-availability: Data Guard, RAC and familiarity with supporting clusters.
  • Must be experienced using OEM Grid Control, tools such as Toad, Spotlight, and Database monitoring solutions.
  • Extensive experience with SQL scripting
  • Must be fully experienced in supporting databases in multiple Operating Systems, especially AIX and Linux.
Required Skills
  • Full DBA skill set
  • Must have excellent interpersonal skills necessary to interact effectively with business and technical resources from multiple organizations and the other members of the team
  • High energy and ethical standards, along with the flexibility to work with a diverse group of people
  • Ability to handle multiple (and sometimes conflicting) priorities effectively
  • Ability to provide / deliver excellent written and oral communications
Desired skills
  • Experience with Oracle Streams and/or database replication is a plus.
  • Expertise of various security technologies from a diverse array of vendors including Oracle, Microsoft, Symantec, RSA, CA, etc.
  • Working knowledge of IT compliance controls
  • Understanding of operating system platforms and security models
  • Strong integrity and highly ethical
  • Experience with MS SQL Server is a plus, but not required
  • Certified Oracle DBA preferred