OBJECTIVE

• To continue to enhance my database administration career through thoughtful and responsible development, implementation, and support of new products and features where the security, consistency and integrity of the data is held in high regard.

SUMMARY

• An energetic self - starter who enjoys working with technical teams on collaborative projects using Agile methodologies to solve business objectives. Significant experience in technologies, participating in virtual teams and projects from inception through production implementation.
• Extensive experience participating with multiple technical teams (on/offshore) on projects using Agile Software Development, coordinating with peers to bring together a cohesive solution. Provides superior customer service, delivers projects on time/budget to meet strategic objectives.
• Over 15+ years of experience engaging with technical teams ranging from 6 to 24 individuals
• Project Management of concurrent projects
• Self-directed, excellent planning, organization and strong interpersonal skills
• Building strong relationships and align stakeholders
• Able to communicate effectively at all levels of organizations both written/verbally and presentations
• Risk management/planning
• Strong conflict resolution skills for critical issues and projects
• Team building, mentoring, coaching
• Innovation planning and process improvement
• Extensive experience supporting infrastructure technology for the Software Development Lifecycle (SDLC) as well as Agile Software Development.
• Production system support of mission critical systems
• Detailed knowledge of product cycle; requirements, design, development, test, release and ongoing support
• Oracle PL/SQL Development
• Strong analytical/problem solving and root cause analysis
• Windows Operating Systems
• LINUX Systems/VM
• Over 15+ Years Database Administration (Oracle)
• 3+ years AWS Aurora MySQL Schema Design Development
• 3+ years MS SQL Server Database Administration
• Database design, data mapping, migration, Reporting & SQL
• Migration of systems/technology refreshes
• Performance Engineering, capacity and scalability analysis

PROFESSIONAL EXPERIENCE

Confidential, McClellen, CA

Senior Database Administrator

Responsibilities:

• PostgreSQL Database Administration
• MS SQL Server Database Administration
• Replacing Human Capital Management System requiring product requirement review of multiple ETL solutions
• Informatica, CloverDX, Dell Boomi, Oracle Cloud Integration, Mulesoft

Confidential, Elk Grove, CA

Manager, Database Administration

Responsibilities:

• Lead team to performance tuning 2 node RAC instances which were performing poorly with additional load
• Used ExtraHop and Nagios to monitor network and server resources to determine trouble spots
• Used Linux systat’s iostat utility to monitor i/o waits during peak application activity
• Used Oracle Advisories to size buffer cache, SGA, and PGA; Deployed into Dev, QA, Staging, and Prod env
• Managed, trained and monitored the development of application schema improvements for Estimator app
• Developed naming standards for new database objects
• Empowered database architect to follow common design practices to normalize the data
• Designed re-runnable schema creation scripts to create new objects in the database reducing false errors.
• Created new data model design to meet business requirements and reducing existing data load by 50%
• Engaged in troubleshooting a cluster rejoin issue with team, working to mitigate customer impact.
• Initiated SR with Oracle Support, pulling TFA and diagnostics, revealing mount times different on instances
• Discovered several high load tables were not indexed properly; Indexes tested and deployed
• Discovered parent company’s patch on firewall server was impeding application web traffic
• Responsible for troubleshooting MongoDB server failure, determine root cause and mitigate
• Discovered team used server for batch process which server was never sized to perform
• Initiated discussion with team to determine real business need could be met with other servers.
• Responsible for troubleshooting MongoDB backup failure
• Discovered server had not been restarted in years, unknown when last backup was taken
• Analyzed resources as under allocated; Coordinated with Configuration Mgmt and Server teams to resolve
• Server restart and new backup taken without issue.
• Scheduled and tasked to create MySQL Database backups of specific databases for development use
• Installed MySQL 8.0 and users on new VM for Data Science team use as a Proof of Concept (POC) effort
• Coordinated with Server team to allocate new Linux VM for MySQL DB to reside on corporate servers
• Initiated gathering business requirements for the POC server
• Created user accounts to allow access from specific users in multiple locations
• Responsible for determining if MariaDB’s column store engine would meet business needs
• Engaged with Senior management to vet business requirements
• Performed Documentation review, Vendor engagement, Requirement design, and received quote
• Engaged Vendors SharePlex and Oracle Data Guard to provide an active failover site rather than Golden Gate
• Performed documentation review, Licensing review, and business requirements gathering
• Determined SharePlex and Oracle Data Guard solves a different business need and could not replace GG
• Drove development of DBA personnel
• Defined all Oracle instances and connections in SQL Developer to improve response time to business units
• Defined all databases and connections in MySQL Workbench to create an inventory of MySQL databases
• Scheduled regular knowledge share sessions with DBA Team to improve team’s knowledge
• Documented on Confluence processes, procedures, templates, and standards for DBA activities
• Participate in database deployments and approved changes into the environment
• Troubleshoot, track and resolve complex database issues, identify recurring problems and apply fixes
• Supported MS SQL Server databases with team
• Approximately 7000 databases supported
• Additional databases added as new customers came online.

Confidential, Folsom, CA

Senior Database Administrator

Responsibilities:

• Working with the development teams, we created a database installer which would fully install Oracle on a customer’s server with very little interaction from the customer.
• Each upgrade or patch install thereafter also was required to work with no on site database administration support.
• The initial database architecture has not changed much since I first laid it out for the Oracle 10c installer.
• The location of datafiles, control files, log files and temp files all have stayed the same.
• Over the years, we have had to create new tablespaces, increase redo log file sizes, temp file design, and make a few init.ora changes.
• These changes typically were handled during an upgrade, however, we consistently applied security patches to the databases by building a new database installer to ensure the database was secure.
• Consulted on schema migration from Sybase to Oracle 10c
• Defined init parameters to be used as the default install for the Confidential Oracle database
• Defined default database file locations for control, redo, archive, datafiles and logs including multiplexing
• Collaborated on the scripting for daily RMAN and Export backups