Experience with Oracle 12c, 11g features.
Coordinate with Enterprise & Data Architects for planning and implementing database solutions.
Lead the Oracle database team both technically and strategically to achieve roadmap goals.
Participate in DevOps initiatives and execute on process improvements.
Design and implementation of Oracle Disaster Recovery solutions.
Reviews, evaluates, designs, implements and maintains company database(s):
Creates database design specifications based on understanding of business transactions.
Designs, codes, tests and implements custom database scripts and formal procedures.
Ensures data integrity; recommends action to maintain data integrity; establishes process / procedures for ongoing data cleanup.
Monitors and maintains databases for proper performance tuning.
Designs, implements and maintains data retention and archival; plans for storage needs, retention, backup and recovery.
Assists in identifying and resolving database problems.
Establishes policies and procedures pertaining to the management, security and maintenance and use of the database management system.
Identifies data sources, constructs data decomposition diagrams, provides data flow diagrams and documents the process.
Support Database Platform Engineering in the architecture, development and deployment of NoSQL technologies like Cassandra, Aerospike and Cloud based environments. This includes, but is not limited to, advanced to expert engineering and implementation of the following:
Manage, support and maintain database technology and infrastructure, adhering to the architectural guidelines and policies
Database administration for off the shelf and internally developed applications, ensure continuous 24x7 operation and availability in support of mission critical business applications
Install, maintain and upgrade of databases
Write/maintain OS level scripts for DB and application maintenance
Provide technical expertise and hands-on support in consolidation and migration of databases to new hardware and platforms
8+ years of working experience in operations team for mission critical environment (Data Center, 365x24x7).
3+ year’s professional experience as an administrator with data store technologies; relational and non-relation data store solutions like Oracle, MySQL, Cassandra, or NoSQL databases and associated practices.
Working experience and scripting in configuration management tools (Chef, Puppet or Ansible).
Strong scripting language skills (Perl or Python and bash) for automating system administration tasks.
Experience with monitoring platforms using tools like Nagios/Wily, Console and Splunk for data reports.
Good understanding of AWS RDS, NoSQL databases, and common components.