SUMMARY:

• I have been involved with relational databases for over 25 years, very experienced with the major commercial and open - source DBMS vendors.
• My focus has been on PostgreSQL for the past 10 years. I wear many hats: Application DBA (SDLC environment), Production DBA, architecture design, performance review/audit.
• I like staying in one place, preferably as a salaried employee, but because of my vast DB experience,
• I often find myself being hired for temporary positions to “put out fires” and tune existing PG installations.
• I love to teach others and contribute significantly in database knowledge transfer.
• I am also a contributor to PG on GitHub and a current editor on official PG wikis.
• Proven ability to meet deadlines in a fast-paced, rapidly-changing environments
• Motivated team player who excels at diagnosing and resolving issues in database technology.
• Proven ability to develop custom scripts and programs to facilitate work goals.
• Proficient in technical writing, knowledge transfer (CMMI Level 3).
• Proven integrator in SDLC environments with AGILE methodologies using Scrum. installation, major upgrades, configuration, security, optimization, performance tuning, monitoring, scalability, replication, full/incremental backups, PITR, import/export utilities, normalization/denormalization, multitenant schema design, High Availability (HA) and Disaster Recovery (DR) design and implementation.
• Entity Relationship Diagramming (ERDs), Data Modeling, Creating Data Dictionaries.
• Expert in ETL, data cleansing, data conversion, and migration, both DDL and DML.
• Use of Explain and other tools to monitor, trace, and analyze complex SQL statements
• Source Code Version control of DDL/DML via Liquibase, git, svn.
• Reporting/Analytic software like Crystal Reports, Jasper Reports, Tableau.
• Integrating database monitoring by way of Zenoss Network Monitoring Tool, Librato.
• Amazon Cloud database integration (AWS EC2/RDS/Aurora, S3).
• Stored procedures coding (PL/pgSQL, PL/SQL, Transact SQL).
• Vertical and horizontal (FDWs) partitioning.
• Reduce Mean Time Between Failures (MTBF) and Mean Time To Recovery (MTTR)

TECHNICAL SKILLS:

• Contributed python-coded PostgreSQL tools
• Python, Linux Bash, C/C++, PowerBuilder, Windows DOS/WSH/PowerShell
• S3, jdbc, odbc, Posix, AIO, Win32, Sockets, TCP/IP, Intex CMO, Code1 Plus, SNMP/IPMI
• Ansible, Docker, git, Stash, Subversion, Mantiss, Bazaar, JIRA, Confluence, Redmine, Rally, Bugzilla, Slack, MediaWiki, G Suite, Jasper Reports (5.1), Crystal Reports (2008/2011), Tableau

PROFESSIONAL EXPERIENCE:

Confidential

Senior PostgreSQL DBA

Responsibilities:

• PostgreSQL SME, AWS EC2/RDS/Aurora, patching/upgrades, PL/pgSQL, psql, backup/recovery, SQL Tuning, replication, PITR, VMWare vPostgres, PostGIS, pgpool2, pgbackrest, Ora2pg, oracle fdw, postgres fdw, pgAdmin III/4, pgbadger, pg repack, pg squeeze, pglogical, repmgr, citus
• MySQL (v5.0, 5.1, 5.5, 5.6) mysqladmin, mysqldump, MySQL Workbench, replication.
• Backup and Recovery (PITR). Percona Server Toolkit/XtraBackup

Confidential

Responsibilities:

• Recover/backup database using RMAN, LogMiner, PL/SQL, Enterprise Manager (AWR, ADDM, ASH, etc.), Grid Control, Streams and RAC configuration, DataPump, SQLPlus, SQL Loader, Erwin, Toad, DBArtisan, SQL Navigator, SQL Developer, Data Modeler, Oracle Warehouse Builder, OCI/C++ development), SQL Trace/TKprof, ERD diagramming, Explain Analysis

Confidential

Senior PostgreSQL DBA

Responsibilities:

• DB2 CLI, Control Center, Data Studio, Tasks Center, Configuration Assistant, Replication Center, Activity Monitor, Event Analyzer, Health Center, InDoubt Transaction Manager, Memory Visualizer, Journal (history analysis), Development Center (used for creating SQL stored procedures), explain, reorg, runstats, backups, DB2 CLI, Omegamon

Confidential

Senior PostgreSQL DBA

Responsibilities:

• SQL/DB2, QMF, File Aid/MVS, Omegamon for DB2, BMC DB2 analyzer, SPUFI, IBM DB2 utilities
• Microsoft SQL Server (2000/2003/2005/2008 )
• Sqlcmd, Transact SQL, Microsoft SQL Server Management Studio (MSSMS), DTS/SSIS tools, performance tools (Database Engine Tuning Advisor, SQL Server Profiler, Replication Services (transaction/snapshot, not merge)
• ASE (Sybase Server v11, 11.5, 12, 12.5) Sybase Central, ISQL, BCP, Sybase PowerDesigner, Transact SQL
• ASA (SQLAnywhere v7, 8, 9) Sybase Central, ISQL, Transact SQL

Senior PostgreSQL DBA

Confidential, Folsom, CA

Responsibilities:

• Architectural Review of all PG and migration to PG projects.
• Design and implementation of Oracle to PostgreSQL migrations on Aurora.
• Implementation of PostgreSQL on OnPrem projects.
• Setup of Cloudwatch monitoring and alerting of f PG log files.
• Parameter Group best practices changes for PG. HA architecture design and implementation.

Senior PostgreSQL DBA

Confidential, Ann Arbor, MI

Responsibilities:

• Identifying performance problems and implementing solutions.
• Creating scripts to manage bloat dynamically. ngoing analysis and monitoring of production systems

Senior PostgreSQL DBA

Confidential , Vienna, VA

Responsibilities:

• Part-time position reviewing and recommending PostgreSQL architecture changes to accommodate future growth expectations
• Identified inefficient OLAP complex queries and optimized them.
• Recommended better postgresql.conf tuning implemented some PL/PgSQL helper scripts

Senior PostgreSQL DBA

Confidential, Chantilly, VA

Responsibilities:

• Architected Terabyte PostgreSQL 10/11 for new application in AWS RDS/EC2.
• Mentored Jr DBAs
• Documented PG best practices
• Conducted PG seminars locally.
• Automated customized vertical partitioning.
• Managed native PostgreSQL 10/11 on local hardware and AWS RDS/EC2.

Senior PostgreSQL DBA

Confidential , Broomfield, CO

Responsibilities:

• Architecture/performance solutions for Host based, and cloud based (AWS RDS) PostgreSQL installations
• Database Access Control design and implementation for multitenant databases.
• Capacity Planning and Performance Tuning python/bash scripting for manual utilities and cron jobs
• Normal PG administrative tasks to optimize clusters.
• Migration of complex Oracle installation to PostgreSQL, lot of manual comversion of PL/SQL to PL/pgsql

PostgreSQL DBA

Confidential, Brookfield, WI

Responsibilities:

• Monitored and tuned all SDLC DB environments: sandbox, test, staging, production
• Worked closely with application developers in solving existing SQL challenges
• Kept up to date with PG security patches, and major upgrades from 9.4 to 9.6
• Incorporated new access control plan including SOX compliancy python/bash scripting for manual utilities and cron jobs
• Scripted Librato for graphing and alerting on concurrent activity, locking, slave lag, etc.
• Integrated backup and recovery using pgbackrest
• Integrated load balancing using pgpool2 multitenant schema maintenance and administration debloating tables/indexes, freezing tuples, analyzing tables, tuning queries, pgbadger customizations minimum down time major migrations with pglogical
• PostgreSQL HA with repmgr

PostgreSQL DBA

Confidential

Responsibilities:

• Solve PG problems, issues, and emergencies as part of company's Proactive SLA aggreements with Customers
• Designing and implementing pgpool 2 HA (watchdog feature).
• Migrating/Upgrading PostGIS
• Backup Management with Amazon S3

Senior Postgresql DBA

Confidential, Atlanta, GA

Responsibilities:

• Identified critical problems with existing configuration, backup crons, and RedHat Clustering failover.
• Successfully migrated Postgresql (9.2-→9.3) with PostGIS (2.-.3-→2.1.3)
• Optimized existing Postgresql configurations, added monitoring extensions.
• Helped to integrate Liquibase into the database product life cycle in an Agile environment.
• Identified and fixed DDL inconsistencies across development environments.
• Documented Postgresql Best Practices on company's internal confluence wiki.
• Help to migrate existing PostgreSQL clusters to Oracle 11g
• AWS EC2/RDS configuration and tuning for PostgreSQL

MySQL/PostgreSQL DBA/Jasper Reports Admin/Developer

Confidential, Chantilly, VA

Responsibilities:

• Creation of time-critical report as basis for cost pricing to clients. (Involved complex stored procedures and Jasper Reports)
• MySQL DBA for terabyte legacy system. Primarily concerned with tuning and monitoring.
• MySQL DBA for new system to replace older one. Installation, Configuration, Partitioning, Turning, Replication, Capacity planning for scalability, etc..
• ETL migration from old system to new system. This involved complex Python program and data map spreadsheet.
• Setting up of cron jobs for backups, monitoring, PITR, Percona XtraBackup, Percona toolkit for monitoring, etc.
• Migration from Percona Server 5.1 to Community Server 5.5.
• Jasper Reports Installation, Configuration
• Jasper Reports Development and creation of RESTful interface from Ruby On Rails App to Jasper Reports Server, job scheduling, etc.
• Lot of Linux tuning for MySQL Server, hugepages, kernel parms, etc.
• PostgreSQL administration: installation, configuration, tuning, backup cron jobs, replication for many small database server instances.

PostgreSQL Database Architect

Confidential, Cincinnati, OH

Responsibilities:

• Tuning configuration parameters for performance, concurrency, and capacity
• Setting up cron jobs for proactive monitoring, automatic database backups, including PITR backups
• Setting up Failover databases using PostgreSQL asynchronous replication.
• Also, served as the senior technical adviser for MySQL, Oracle 11g

Senior Production DBA

Confidential, Chantilly, VA

Responsibilities:

• Oracle 10g RAC (3 node cluster):
• Create and maintain data dictionary with emphasis on business rules
• Maintain/Restore using RMAN.
• Find existing database areas for improvement (remapping of tablespaces, adding indexes, etc)
• Help improve database analytical skills of an existing DBA who was converted from a System Administrator
• Create Crystal Reports based on business areas needed for analytical study
• Review SQL developed by programmers
• Create monitoring tools using python and Zenoss API
• Maintain DDL via Liquibase
• SQL Server 2008:
• Identify indexes that needed to be defragmented and rebuild them
• Backup and restore database instances via SQL Server Management Studio
• MySQL 5.1/5.5:
• Identify areas of performance improvement
• Backup and restore database instances
• Create monitoring tools
• Migrate DDL and DML from Oracle, and maintain DDL via open source liquibase product.
• Postgresql 9.1/9.2:
• Install, configure, administer
• Migrate DDL and DML from Oracle
• Setup synchronous replication servers

Senior Technical Developer

Confidential, Annapolis, MD

Responsibilities:

• Ported 32/64 bit windows applications to Linux.
• Customized clustering software: glusterfs/clustered samba.
• Integrated Zenoss Monitoring Dashboard using bash/python scripts with MYSQL database backend.
• Helped set up CM environment using Bazaar and Mantis.
• Configuring and enhancing Glusterfs with Zenoss Dashboard using batch scripts and Nagios plug-ins.
• Data modeling using Smartdraw

DBA/Database Developer

Confidential, Annandale, VA

Responsibilities:

• Created data-mapping documents, and data modeling (Erwin). Converted the Erwin diagrams to Sybase PowerDesigner.
• Implemented data migration processes using Oracle Warehouse Builder (OWB).
• Create PL/SQL packages to assist java development effort for the new Web-based applications using Oracle SQL Developer and Quest Toad for Oracle.
• Application DBA role with emphasis on performance tuning.
• Analyzed and recommended procedural changes to ensure best practices for SDLC across heterogeneous systems.
• Created tools in C, C++, and PowerBuilder to assist in version control (PVCS) and packaging of product.
• Integrated PVCS into the PVCS Tracker system using version labels and promotion groups.
• Wrote a version control administration guide to document the complexities of the sophisticated version control system layout.
• Provided DBA mentoring to the DBAs, and recommended performance enhancement changes to the Sybase Enterprise Server database involving update statistics, recompile stored procedures, and rebuild/reorg indexes.
• Created Erwin logical data models based on existing physical databases.
• Generate SQL scripts to migrate databases from SQL Server to Oracle with associated data-mapping documents.
• Java development within Archibus Web Central Framework.

DBA/Data Analyst/ETL Expert

Confidential, Reston, Virginia

Responsibilities:

• Wrote C++ program to generically extract data from heterogeneous database sources using ODBC, SQL statements, and transaction start/end points.
• Used DTS Bulk Export Task to extract information from SQL Server databases to Ascii flat files.
• Used business intelligence objects in SSIS to extract information from SQL Server databases to Ascii flat files.
• Used SQL Loader with control files to upload external data to temporary tables.
• Created Oracle PL/SQL packages using Toad to transform and move the temporary tables to the staging database for the central Oracle Data Warehouse.
• Created data mapping documents.
• Helped in the design and configuration of tables in the data warehouse schema using elements of both star and snowflake methodologies.