TECHNICAL SKILLS

• AWS DocumentDB
• Aurora Postgres
• Redshift. Postgres 9.2
• 9.4 and 9.6. MongoDB. Oracle 10g
• 11g
• Data Guard
• Streams and Advanced Replication
• RAC and ASM. AWS RDS and EC2. EnterpriseDB Advanced Postgres SQL Certified DBA. SQL Server with Replication. MySQL
• Informix
• Vertica
• GIS Systems support. Performance tuning. Cold and hot backup and recovery
• RMAN installation and configuration. Datapump export/import utilities. Database creation migration upgrade and patching. Sun
• AIX
• HP
• Linux. Bash shell scripting and Python. Ansible
• Yaml
• Git. Design implement and maintain geo - redundant disaster recovery solutions. Certified Scrum Master.

PROFESSIONAL EXPERIENCE

Sr. DBA AWS Engineer

Confidential, Denver, CO

Responsibilities:

• Provide ongoing DBA support for MongoDB, Postgres, DocumentDB and Aurora databases. Use AWS Database Migration Service (DMS) to move databases within and into the cloud infrastructure. Create documentation, procedures and standards for ongoing development work. Design and build test systems to support migrations, installs and upgrades for all levels of the database lifecycle. Support the move from MongoDB to DocumentDB and Postgres to Aurora. Evaluate software, hardware and logical solutions.
• Administer multiple complex environments comprising diverse database types with differing timelines, procedures and requirements while coordinating changes with various groups throughout the organization. Troubleshoot all database or database related issues from connection problems to system wide outages. Quickly and efficiently diagnose, mediate problems and return systems to a functioning state. Produce fixes, redesign and implement changes to prevent the similar issues from recurring. Provide technical detail at the appropriate level for stakeholders throughout the organization.
• Create, modify and extend existing scripts using Bash, SQL/NoSQL and python languages for database management, monitoring and automated user creation of new systems. Extend environments using ansible and git while utilizing Agile principles.

Staff Cloud Operations DBA

Confidential, Broomfield, CO

Responsibilities:

• Originated the role of DBA at Confidential . Identified and corrected deficiencies in all aspects of database lifecycle. Established geographically redundant disaster recovery sites and created multi-database replication strategies. Designed, developed and maintain a system producing regularly scheduled database dumps scrubbed of sensitive client information (PII) for use by development and engineering resources. Created the procedures, timelines and documentation required for all tasks as needed to support users, administrators and management. Created test system allowing destructive testing of database changes with production data.
• Develop and run weekly DBA engagement meetings to identify issues, provide feedback on changes in Production to the Development and Engineering teams and give visibility to the results of changes to the database. Handle complex changes, updates and events on diverse systems with multiple users and support groups on separate timelines. Perform as SME in all phases of the database lifecycle. Interact with all levels within the company to provide technical explanations and procedures.
• Administer multiple mission critical replicated database systems containing sensitive client data in Linux and AWS based environments. Quickly assimilate new features, software and procedures while assessing and reducing risk. Create scripts to verify the objects documenting the discrepancies between our company and newly created AWS cloud databases identifying and reducing the code issues moving between systems. Respond to auditing concerns and provide the path to resolution. Complete the required procedures, in the time specified and document the results.

Sr. DBA

Confidential

Responsibilities:

• Supported replicated systems of test and production Oracle 11g, Postgres, SQL Server, MySQL, Informix, Vertica and MongoDB databases running on a variety of operating systems; some with 99.999% availability requirements for 911 services in the US and Canada. Created RAC and ASM systems, replicated data in Oracle, Postgres, MySQL and SQL Server. Performed on-call duties covering 80% of the 911 services in North America.
• Analyzed database and application artifacts (dump files, error logs, etc) from incidents and events to create solutions in time sensitive environments supporting 911 call path applications. Identified and corrected weaknesses in scripts, systems or processes that could impact system performance or usability. Provided support to multi-database GIS based system for geolocation of 911 calls including loading of ARCGIS data on a semi-quarterly basis, performance tuning, and capacity planning.
• Mentored team of database administrators in technical matters. Created performance tuning and Intro to Streams class and documentation for fellow DBAs. Created and presented PowerPoint presentations recommending future development direction. Presented to the company governance board on technical subjects. Maintained rigorous change control records of events and incidents, produced event handling documentation and other documentation for all technical levels. Created multiple forms of MOPs (Methods of Procedure) utilizing Wiki-pages, Microsoft One Note, Word, and InfoPath to document changes to the systems under my control.

Sr. Oracle DBA

Confidential, Boulder, CO

Responsibilities:

• Managed Oracle 10g environment comprised of 7 databases which holds the largest collection of student gathered Geo-Science data in the world, from over 130 countries.
• Oracle Multi-Master Streams environment allowing a 24/7 uptime capability along with a system of cold backups for ease of maintenance and recovery.
• Migrated entire database system from Xen to VMWare virtual machines using RMAN, Data Pump export and import, and graceful failover.
• Produced short video on The GLOBE Annual Meeting 2011 field expedition to Patauxent National Forest and NASA Goddard Space Center.