SUMMARY:

• 20+ years in the IT industry, with experience with Microsoft SQL Server (15 years), Oracle (13 years), and Mongo (3 years) database administration, development, and data architecture.
• Self - starter who works well alone and with a team. Worked remotely a lot at UMB and other companies sparingly.
• Self-managed my work at UMB with very little supervision. Known for getting things done on time.
• Will work under pressure for incidents of project deadlines while keeping management informed.
• A resourceful problem-solver and effective communicator who takes ownership of work.
• Experience in being the DBA who works on a panel that evaluates new products that the business unit wants. Ensures the product’s RDBMS meets company standards, based businesses RTO and RPO requirements the business is made aware of all hardware/disk/RDBMS licensing costs, and project manager is made aware of all DBA related tasks.
• For all 20+ years has been in an on-call rotation supporting the databases 24/7.
• DBA experience includes installation, configuration, importing/exporting, patch installs, capacity planning, backup and recovery of mission critical databases.
• Performing preventive and corrective maintenance to meet goals for system up time and stability.
• Troubleshooting production issues and raising high availability, and conducting root cause analysis for database incidents.
• Experienced in SQL, PL/SQL programming, T-SQL, PowerShell, Unix/Linux shell scripting and performance tuning.
• Troubleshooting database production incidents, conducting root cause analysis, and implementing changes so issue will not happen again.
• DBA(Developer)
• Early on years was a dedicated developer/data analyst.
• Assisted developers with writing and tuning SQL queries; performed on-call support and problem resolution 24/7.
• Experience in architecting Data Models, developing SSIS ETL jobs, Data Scrubbing, Stored Procedures/Functions/Views, maintaining SSAS cubes, creating SSRS Reports, shell scripts, PowerShell scripts, and mentoring developers and DBAs.
• Experienced in SQL, T-SQL, and PL/SQL programming and performance tuning.
• Attributes
• Projects a proactive, solutions-oriented approach to problem solving, has sound judgment and decision-making abilities, works well under pressure, multi-tasks and able to follow instructions precisely; a team player who can work independently.
• Resourceful problem-solver and effective communicator.
• Ability to take on new technology, understand, implement, and manage it.

TECHNICAL SKILLS:

Technologies: Oracle 7/8/9/10, Microsoft SQL Server 2000/2005/2008 r 2/2012/2014/2016, Mongo 2.6/3.2, MySQL 3/4/5, VMWare, EMC XtremIO, EMC DDBMA, EMC RecoverPoint, PowerShell, KSH, SSIS, SSRS, SQL Profiler, SQL Query Analyzer, T-SQL, PL/SQL, Windows, UNIX, Linux Server Systems, AWS, Cloudera, VMWare

T ools: Oracle Enterprise Manager, SQL*Plus, VMware vSphere Management Assistant, SCOM, BMC/PATROL, IDERA Diagnostic Manager, NetBackup, NetBackup SQL Server Agent, IDERA ER Diagram Tool

PROFESSIONAL EXPERIENCE:

Confidential, Kansas City, Missouri

SQL Developer

Responsibilities:

• Moving Report from Mainframe to SQL Server SSRS
• Created Reports in SSRS (Difficult)
• Review and some creation of SSIS
• Evaluated new system databases that was just implemented.
• Developed queries to emulate what the mainframe was doing.
• Filled in a spot on the team until they could find a fulltime employee.

Confidential, LENEXA, KS

SQL Server DBA/Developer/Data Architect

Responsibilities:

• Reviewed current SQL Server instance configuration, then advised and implemented changes on their current SQL Server instance as it pertained to:
• SQL Server instance, security, database settings, and inferential integrity;
• Improving stored procedure performance and manageability.
• Build a relational schema to import the data.
• Evaluated very large XML files in a tree of windows folders
• Built PowerShell and stored procedures to load and extract information from XML and HTML documents in 100’s of folders into a data model that I did the data architectural work and implementation.
• Documented scripts and suggestions for change to increase performance and security; an instruction on how to load the repository with hundreds of thousands of documents.
• Client was very happy with the outcome.

Confidential, KANSAS CITY, MO

SQL Server DBA and Developer

Responsibilities:

• Monitored and managed database backups, logs, and journals and installed, maintained, and upgraded database software.
• Received work from a SharePoint system that routed DBA requests.
• Re-work of SQL or stored procedures to improve performance and lower load on server.
• Data Security tasks to create, alter, and delete users while following security procedures
• Build stored procedures and views to suite requirements of the developer
• Implement Developer code immediately or during maintenance depending on impact and on approvals.
• Spearheaded the patch management program for all database servers.
• Was on a 24x7 on-call support rotation with 2 other DBAs for database and server issues.
• Migrated a MySQL database to SQL Server in a very creative way. The MySQL tables had over 2000 columns.
• Implemented two mission critical, 2-node clusters running SQL Server on top of EMC XtremIO that were 1 Terabyte and 3 Terabytes in size. These nodes were the heart of the company so great care was given to migrating the old single nodes to the new clustered nodes that were replicated to a disaster recovery site.
• Created procedures and maintained various database related documents.
• Implemented a Mongo infrastructure from scratch. This was an environment with a 5-node replica set in Production, one stage database refreshed daily with automated SQL Server jobs, and a development environment. Accomplished in 2 months of intense work.
• Implemented DR solution for near zero data loss via EMC RecoverPoint and then actively failed over and ran Production from the DR side.
• Implemented and tested an AlwaysOn Availability Group for future use and submitted my written findings.
• Managed the storage requirements for SQL Server and Mongo database instances through an automated SSRS reporting system that I built.
• Maintained Development, Test, and Production DBMS environments.
• Help develop a refresh system to our non-production instances from production backups.
• Monitored and maintained database security and database software, in cooperation with corporate security guidelines.

Confidential, KANSAS CITY, MO

Senior Oracle Database Administrator, SQL Server, and MySQL DBA

Responsibilities:

• On-call rotation, 24x7, for Database related issues with other DBAs.
• Supported over 300 instances, +4000 schemas/databases in non-clustered and clustering environments (A/P), +16K database users, and databases of 7TB in size and smaller.
• Assisted with the team to implement RAC on
• Mentored DBAs and developers in the use of SQL coding and management.
• Worked with customers on application rollouts and server migrations.
• Formulated and monitored policies, procedures, and standards related to database management.
• Monitored data activities (i.e., database status, logs, space utilization, extents, checkpoints, locks, and long transactions).
• Researched, reviewed, and implemented preventive maintenance.
• Interfaced with database vendors and client technical support teams to isolate and resolve database related problems.
• Enterprise level hands on experience.
• Created an Oracle and SQL Server watch dog system that would monitor all instances as to their adherence to standards, reported on forecasted disk shortages, and reported on suspicious activities.
• Created SSIS and SSRS packages to report on data gathered.
• Did troubleshooting and fine-tuning of the databases for performance and availability.
• Implemented changes to production during maintenance window and making sure turnover to production was complete and faultless.
• Designed and implemented architectural physical layout on how we could build a high performance, reliable system.
• Hands on technical development in building, implemented and maintaining a 7TB data warehouse solution.
• Created and maintained stored procedures/scripts/utility jobs as needed for database maintenance.
• Created stored procedures and scripts to automate day to day tasks.
• Created ETL SSIS packages to load Oracle data into SQL Server.
• Managed security and backups of SSAS cubes.
• Supported the application development teams in optimizing tables, indexes, stored procedures, triggers, and ad-hoc T-SQL.
• Diagnosed problems using tools such as BMC Patrol, SQL Profiler, Database Tuning Advisor (DTA), Perfmon (System Monitor) with vendors and developers to resolve performance issues.
• Tuned indexes and reduced I/O bottlenecks.
• I installed, authored, and managed reports using SQL Server 2008 Reporting Services.
• Technically hand on work to drive projects tasks to make sure they stayed on schedule and within our architecture.
• Implemented MS SQL Cluster (Active/Passive) for Online Banking system.
• Resolved database performance issues by reducing the database size by 45%, increased server memory by 62%, and created a job to monitor table blocks and deadlocks.
• Participated in implementing and testing the Enterprise Disaster Recovery Plan.
• Became a certified Data Architect.
• Responsible for the management of Oracle licensing and database metrics.
• Implemented many financial and policy management systems’ databases.
• Created Database Standards for installs, maintenance, and incident management.
• Spearheaded a communication program to better communicate day-to-day activities and status.

Confidential, Saint Joseph, MO

Owner and Operator

Responsibilities:

• Had a clientele averaging around 25.
• Met with clients to find out their needs and to get content.
• Housed it out of my home on dual processor rack server until 2006.
• Built the servers with RedHat and MySQL along with necessary libraries.
• Created shell scripts to manage.
• Setup opensource portals (PostNuke, Mambo, Drupal, Joomla, etc.…) with the MySQL instance.
• Managed client education, questions, and problems.

Confidential, KANSAS CITY, MO

Oracle DBA Lead

Responsibilities:

• The only DBA onsite at this location.
• On-call 24x7 for Oracle databases.
• Implemented a data warehouse for the company.
• Migrated Oracle off of VMX/VAX to a Solaris Server running onto of HP’s Auto Raid storage system. This increased the performance of the manufacturing parts inventory system by 300%.
• Served as the Oracle DBA, managing the database performance issues in tools, OLTP, and warehousing.
• Responsible for all day to day work insuring that all maintenance was done and backups succeeded.
• Directed remote DBAs around the world on resolving issues and administration. Systems were a mix of Sun, HP, and VMX/VAX.
• Responsible for the management of Oracle licensing and database metrics.
• Managed Data Warehouse size and schemas.

Confidential, KANSAS CITY, MO

Oracle DBA

Responsibilities:

• Served as an Oracle and SQL Server DBA, Data Architect, Data Analyst and programmer.
• Attended all foundational classes for an Oracle DBA offsite. I lived and breathed Oracle and within one year I was asking questions the Senior DBAs did not know.
• Served as a member of the Unix System Administration team, overseeing and monitoring 4 NCR platforms, 6 HP Platforms, and 2 Unisys platforms.
• Worked on-call, 24x7, for Unix Admin and DBA related issues.
• Implemented and maintained the interface system to the first large-scale in the United States a wireless integrated network to do wireless electric meter reading.
• Developed Unix script to handle daily checks on Oracle processing.
• Responsible for being the data analyst of two databases where one was Confidential ’s that saw all data in relation to a customer and from Celitas’s (contracted by Confidential to implement the system) that saw all data in relation to electric meter. Found errors and put in changes to align the data.
• Developed and trained users on how to use Oracle Forms to access customer data.
• Responsible for COBOL programming of Teradata data transfers and customer billing.