SUMMARY

• Seeking a career as a Senior PostgreSQL Database Administrator/Solutions Architect in Database Management Systems and Database administration in Multi - platform Linux/CentOS/Windows server environment within Enterprise systems, Government and private corporations including Higher Education, Health care, and Financial Institution in a world-class organization that would provide competitive and challenging work environment to exploit my potential and augment my skills.
• Over 12 years of experience in Database Administration Manager, Oracle Database Administrator, Data Warehouse and Oracle Applications DBA, MS SQL server dba to include over four years of actively working as senior PostgreSQL dba and Solutions Architect
• Experienced in Managing, Installing, Deploying, Administering, Upgrading, Migrating, Performance tuning of various databases including, Microsoft SQL database, PostgreSQL, Confidential (EDB) advanced server (AS11x), Oracle 12c, and AWS Cloud Migration and deployment Technologies
• Experience as Senior Database Administrator related to Higher Education, Financial, Insurance, Health Care domains and worked on various database including community PostgreSQL 9.x, 10.x 11.x, 12.x and edb advanced server as10.x, as11.x, 12.x on Linux 7.X platform.
• A thorough understanding of Oracle and PostgreSQL database installs, patches, management, monitoring, backup and recovery, security, and replication skills.
• In depth knowledge of PostgreSQL, and Oracle Database Architecture, Automatic Partition Management, Bloat Diagnostics and resolution, Database Backup/Restore, and DR Planning, Change Management and Monitoring Utilities.
• In depth knowledge of Data Modeling, including logical and physical design, re-engineer existing models for data mart, data warehouse, OLTP (Online Transaction Processing) databases using Oracle and PostgreSQL database technologies.
• Installed, Administered and configured PostgreSQL Cluster including Backup, Restore, Replication, Migration from Oracle Database and Troubleshooting as required.
• Set performance Tuning Parameters in the PostgreSQL database including auto-vacuuming for BLOAT and other performance related issues.
• Perform advanced health check (ACH) and performance tuning for PostgreSQL databases.
• Major and Minor Upgradation PostgreSQL., Setup Security baseline for PostgreSQL server and Setup Streaming Replication.
• Proficient with PostgreSQL, EDB’s PostgreSQL Enterprise Manager (PEM), EDB’s Backup and Recovery Tool (BART)
• Proficient with PostgreSQL database architecture
• Experience in AWS data migration
• Experience in db migration with aws RDS and AWS DMS
• Familiarity with Pivotal Cloud dba migration and administration.
• Extensive knowledge in Aws data migration from oracle to PostgreSQL
• Familiarity with Greenplum database architecture
• Knowledge of recommended best practices for building secure and reliable applications on the AWS platform; understanding of the basic architectural principles of building on the AWS Cloud; knowledge of the AWS global infrastructure; understanding of network technologies as they relate to AWS
• Sound understanding of security features and tools that AWS provides and how they relate to traditional services; proven experience assessing clients workloads and technology landscape for Cloud suitability, develop business case and Cloud adoption roadmap
• Experience with SQL Server Migration Assistant (SSMA) is preferred
• Proficient with database design and building applications for PostgreSQL, Oracle, or other databases
• Working knowledge of scripting languages like BASH, KSH, Python, JAVA, JSON and JSONB
• Setup EDB Failover Management (EFM), Setup EDB PostgreSQL Enterprise (PEM) for monitoring
• Experience in Shell scripting and automation
• Maintain custom vacuum strategies at table, schema and database level.
• Working knowledge on Database Migration Assessment (DMA) report.
• Migrate the PostgreSQL Database using EDB Migration Tool Kit & XDB.
• Proficient in BART Backup & Recovery for PostgreSQL databases.
• Familiarity with Red Hat Ansible Engine and Red Hat Ansible Tower
• Experience in Deploying PostgreSQL on a Docker Container
• Experience in Cloud deployment on Docker container with Kubernetes
• Experience in EDB Postgres Containers and Integration with OpenShift
• Extensive knowledge in AWS cloud deployment
• Migrated Oracle RDBMS to PostgreSQL using ora2pg tool.
• Strong skills in SQL and PL/SQL
• Strong interpersonal, motivational, writing and verbal communication skills.

TECHNICAL SKILLS

DATABASES: PostgreSQL 10, 11, EDB Advance PostgreSQL as10, as11, Oracle 12c, Oracle 11g, 11g RAC, MS SQL Server 2012, MS SQL Server 2016, Degree Works, CQ5, CMS Repository, Greenplum, PostgreSQL.

TOOLS: and APPS: AWS-WorkSpace, pgloader, pg dump, pg restore, Jira, EC2, AWS-RDS, AWS-DMS, Kubernetes Cluster, Docker, Hadoop Distributed Programming Framework, HDFS, loading, and managed unstructured data, as well as writing basic to advanced MapReduce Programs, SQL, Import/Export, SQL*LOADER, SQL*PLUS, SRVCTL, Oracle Enterprise Manager (OEM), Oracle Procedure Builder, DBCA, DBUA, OEM, RMAN, UTLSTAT, Explain plan & TKPROF, expdp and impdp, ASM, AWR, ADDM, ADRCI, Data Pump, Data Guard, STATSPACK, Oracle Grid Control, Replication (Stream), ODBC, UNIX shell scripts, Korn Shell(.ksh), and Bourne-, Banner v.8, Oracle Fusion Middleware, Banner XE, Banner Data Defense (BDD). PeopleSoft 8x, Docker, Puppet, Jenkins, WUG, Citrix, CRDB, CMS, Visio, CRXDE Lite, JDBC, Java Script, JSP, J2EE, Eclipse, Net Beans, HTML, Java Servlets, JBoss, JDBC, HTML, JavaScript, EJB. TOAD dba tools, SQL, and PL/SQL ERWIN, COGNOS Reporting, Adobe Experience Manager 6.2, Adobe CQ5, Adobe Content Management Systems (CMS) and Jackrabbit Oak repository for web developments, NetBeans, IBM SPSS 2016, GitLab, and GitHub, Oracle Data Integrator (ODI), Putty, WinSCP, SFTP, LDAP, Active Directory (AD), PgAdmin 4

PROGRAMMING LANGUAGES: SQL, PL/SQL, C/C++, Groovy, Grails, Python, and java, json, jsonb, Bash, Bash Scripting, AWK, Node.JS

NETWORK TOPOLOGYS: TCP/IP, DNS, WINS, DHCP, FTP, SNMP, SMTP

OPERATING SYSTEMS: REDHAT Linux 7x, CentOS-7x, UNIX, and Microsoft Servers 2012R2 and 2016.

PROFESSIONAL EXPERIENCE

Confidential, Harrisburg, PA

Solutions Architect Consultant

Responsibilities:

• Implement and monitor replication for high availability and disaster recovery scenarios.
• Query errors logs, debug errors, export logs, and export sql statements errors logs for troubleshoot.
• Evaluate and rewrite functions, evaluate overall database performance and query optimization.
• Load data from a text file or csv files or from flat files in a PostgreSQL database
• Administer and troubleshoot PostgreSQL version 11 databases.
• Worked on AWS Migration Architecture, Design including AWS SCT (Schema Conversion Tool)
• Worked on AWS Migration/AWS RDS/AWS DMS services.
• Worked on Migrating from IBM DB2 to PostgreSQL 9.4/PostgreSQL 11.6
• Data loading using bash scripts from IBM db2 to Amazon RDS and aurora PostgreSQL
• Error diagnostics, identify missing data in data loading process, executing db comparison and provide solutions and recommendations to co-workers.

Environment: Community PostgreSQL 10.x, 11.x, PostgreSQL community version, PL/SQL, PL/pgSQL, SQL, Python, Linux server 7x, Pg Admin, SQL Shell (psql), aws EC2, AWS-WorkSpace, JIRA and Confluence.

Confidential, VA

Senior PostgreSQL Database consultant

Responsibilities:

• Implement and monitor replication for high availability and disaster recovery scenarios.
• Query errors logs, debug errors, export logs, and export sql statements errors logs for troubleshoot.
• Evaluate and rewrite functions, evaluate overall database performance and query optimization.
• Load data from a text file or csv files or from flat files in a PostgreSQL database
• Administer and troubleshoot PostgreSQL version 11 databases.
• Create new PostgreSQL database and upgrade existing database as required.
• Troubleshoot database server disconnection errors or timed out errors as it happens.
• Develop functions, query scripts and optimize with explain, vacuum, explain analyze for slow query performance related issues including MVCC model and clean Bloating by vacuuming table level and database level.
• Use PgAdmin 4 for database maintenance and user management.
• Use ODBC connection to connect to databases as well as RDP connection
• Upgrade PostgreSQL 10x to PostgreSQL 11x with Zero Downtime
• Windows Command Line Database performance tuning, error diagnostics and data retrieval activities

Environment: Community PostgreSQL 10.x, 11.x, PostgreSQL community version, PL/SQL, PL/pgSQL, SQL, Python, Windows Server 2012 R2. Pg Admin, SQL Shell (psql), PSQL, Windows PowerShell, PowerShell scripting, Windows Command Line Database performance tuning, error diagnostics and data retrieval activities.

Confidential, Bedford, MA

Senior Database Consultant

Responsibilities:

• Assisting Clients with DMA assessments, hardware compatibility architecture and design, install, setup, migration and upgrade databases and applications to PostgreSQL standard and EPAS10x and EPAS11x.
• Implementation readiness software package for Confidential client’s requirements for engagement. The Confidential readiness package includes community Postgres or Postgres Advanced Server installation.
• Setup up synchronous or asynchronous streaming replication, efm failover manager, BART backups and recovery tool, and PEM monitoring installation and configuration.
• Install & configure EPAS cluster 9.5, 9.6, 10.5, 11.1, 11.2
• Maintain all Development, QA, Staging and Production PostgreSQL databases within the organization.
• Setup streaming replication, Install & configure Enterprise Failover Management (EFM)
• Install & configure Postgres Enterprise Manager (PEM), Setup alerts in PEM
• Setup Security Baselines Parameters in PostgreSQL
• Prepare AHC report in PostgreSQL, Working on performance related issue in PostgreSQL
• Minor/Major Upgradation in PostgreSQL
• Work on Oracle to PostgreSQL Migration, Prepare DMA report in PostgreSQL.
• Collaborate with the database administration team to implement EDB PostgreSQL Advanced Servers epas10X and epas11X.
• Implementing and administering backup and recovery (BART), setting up and administering edb-postgres failover and replication cluster.
• Synchronous and asynchronous replication and failover for High Availability (HA) protocol. Setup streaming replication for open source PostgreSQL database.
• Install & configure Enterprise Failover Manager (EFM), Install & configure Postgres Enterprise Manager (PEM), Setup alerts in PEM
• Setup Security Baseline Parameters in PostgreSQL, Prepare AHC report in PostgreSQL, Working on performance related issue in PostgreSQL
• Minor/Major Upgradation in PostgreSQL, Setup Replication using XDB.
• Provide the training and knowledgebase on PostgreSQL to Customer, Prepare the Documentation for all the project level work.
• Implement data models, database designs, data access, table maintenance and code changes together with our development team.
• Working on Oracle to PostgreSQL Migration, Prepare DMA report in PostgreSQL.
• Setup up of PEM (Postgres Enterprise Manager) servers with agent connection configuration, adding agents and clients and importing alert templates for continuous monitoring process.
• Working to migrate mongodb to Postgres. Creating new table structures using java, java scripts, and json and jsonb data type.
• Knowledge of recommended best practices for building secure and reliable applications on the AWS platform; understanding of the basic architectural principles of building on the AWS Cloud; knowledge of the AWS global infrastructure; understanding of network technologies as they relate to AWS
• Sound understanding of security features and tools that AWS provides and how they relate to traditional services; proven experience assessing clients workloads and technology landscape for Cloud suitability, develop business case and Cloud adoption roadmap
• Worked on migrating databases from Oracle to PostgreSQL on AWS environment
• Experience with SQL Server Migration Assistant (SSMA) is preferred
• Configuration of postgresql.conf for database server configuration and pg hba.conf for controlling client connections and authentication
• Implementation of Load Balancer - Connection - Pooling-pgBouncer with edb fail over architecture.
• Create and manage edb advanced server as10X and as11X and PostgreSQL databases including create database, create schema, and create roles, create indexes, create database users and authentication roles, manage security with encrypted password for edb advanced server architectures,
• Load flat files load external files into databases and perform export and import of datafiles as needed with Pg Dump and copy command.
• Implement and monitor replication for high availability and disaster recovery scenarios.
• Query errors logs, debug errors, export logs, and export sql statements errors logs for troubleshoot.
• Load data from a text file or csv files or from flat files in a PostgreSQL database
• Troubleshoot database server disconnection errors or timed out errors as it happens.
• Use PgAdmin 4 for database maintenance and user management.
• Upgrade PostgreSQL 10x to PostgreSQL 11x with Zero Downtime
• Upgrade edb database server using pg upgrade utility
• Migrate from an earlier version of Advanced Server 10 to Advanced Server 11
• Worked on Migrating from Oracle 11gg to PostgreSQL PostgreSQL 11.6

Environment: Community PostgreSQL 10.x, 11.x, EPAS10, EPAS 11, Bitbucket, Atlassian, SharePoint, share file, Confluence, Jira, DMAT, OKTA, github, ansible, PostgreSQL MTL (Migration Tool Hit), community version, Confidential, BART, Pem, EFM, PS tools. PL/SQL, PL/pgSQL, SQL, Python, Red Hat Enterprise Linux 6x, and 7x

Confidential, Radford, VA

Manager of Database and Application Admin

Responsibilities:

• Acts as project liaison for team and coordinate with other departments regarding installations, upgrades, patches, and other maintenance activities. Plan for system outages and coordinate communications with Enterprise Systems management and campus user groups.
• Collaborated with the data warehousing team to plan, design dimensional models, and implement ETL processes for Data Marts including source to target mapping, table/partition creation with appropriate compression algorithms, function-to-table mapping in line with Load and Transformation best practices.
• PostgreSQL database creation, management, patching, upgrades, data migration, backup and restore of schemas, and database, including Stored Functions development for Data Warehouse environments.
• Collaborating with ETL and Business Intelligence teams for performance tuning Data Warehouse related databases. Database audit - managing to PCI, PII, and SOX compliance in Oracle and PostgreSQL databases.
• Identified deficiencies in resource queues definitions and workload. Recommended and created database resource queues to optimally manage system resources and workload.
• Defined shell to diagnose bloat and missing statistics in large tables, and resolved excessive space usage, with vacuum analyze of system catalog, and schema objects.
• Configuring and Managing DataGuard and Standby Databases in a High Availability environment. Managing Enterprise Data Warehouse environments that integrate with OBIEE, Informatica, and Pentaho for data analytics and ETL processing with interfaces to Oracle 11g, and PostgreSQL databases.
• Working with Cloud Ops. to optimize & manage virtual & hardware resources
• Create tools and processes to automate administration and monitoring
• Experienced in data transformation services and Bulk Loads with SSIS and BULK INSERT ETL operations. Created DTS package for data transfer between the two environments including Microsoft 2008 R2 and Microsoft SQL 2016 servers.
• Worked on DR processes including Log Shipping and Database Mirroring. Worked on logical and physical data base modeling with UML and ERWIN tools,
• Worked on upgrading banner 8 to Banner 9 in a team effort. Transforming custom INB forms to Admin Pages in Java. Setting up Github to manage code (Banner-related Java, Groovy/Grails, PL/SQL, etc.). Implementing Banner 9 Self-Service Banner (SSB) and Registration.
• Actively worked on database security options and data transfer and integrations using Oracle Data Integrator ODI utility.

Environment: PostgreSQL, Greenplum, MS SQL Server 208, MS SQL server 2012, Windows server 12 -R2, Oracle 11gR2, 12c, Ellucian Banner 8X, Banner 9, Ellucian Degree Works, Oracle OEM, Hadoop Distributed Programming Framework, HDFS, SQL Developer, PL/SQL Developer, apache, Tomcat, Java, java scripts (Jason), PL SQL Developer, SQL Loader, Windows 10, RMAN, SQL*Plus, SQL, UNIX Shell Scripting, Oracle OEM, Import/Export Data pump, Linux 7 server with Oracle 11gR2 and Oracle Fusion Middleware, Informatica ETL tools, Docker, Puppet, Oracle WebLogic, Banner Data defense, Oracle Firewalls, Operational Data Store (ODS) and Data ware house, Cognos Reporting, Odyssey-HMS, AEM 6.2, CMS repositories, WhatsUpGold (WUG), LDAP and Active Directory.

Confidential

Manager of Database and Administration /Lecturer/Trainer

Responsibilities:

• Provide guidance and direction to DBA, oracle and banner programming staff and coordinate projects and tasks for the team. Troubleshoot and resolve complex or critical technical issues. Provide guidance and direction to the Database & Administration team for the development, implementation and administration of oracle database and Ellucian banner enterprise application systems.
• Create, maintain and refresh required Oracle databases for development, test and production environments and Collaborate with the IT Technology Committee and Directors of related Administrative offices to establish and manage user access and implement/maintain identity architecture.
• Worked on Data transferring with export/import utilities and Data pump. Experienced in Hot/Cold Backup and Recovery and Cloning of databases using RMAN. Worked on cloning or duplicating databases manually for developer. Highly experienced in performance monitoring/tuning/troubleshooting.
• Performed database tuning using Explain Plan, and Enterprise Manager Grid control and oracle provided ADDM and AWR tools. Resolves data redundancy and facilitates data normalization and rationalization. Evaluates and implements new initiatives on technology and process improvement.
• Manage Banner ERP application update process and oversee patches and update process. Respond to issues, trouble-shoot, and repair issues with Oracle databases and associated applications including Banner.
• Monitor IT systems, report suspicious events, and take appropriate action to resolve security issues
• Assist in the planning and design of database physical structures to accommodate large transaction processing and high availability. Perform database and application monitoring and tuning to ensure databases run at peak performance; troubleshoot performance issues. Assist in the analysis for database sizing/capacity, server requirements and space requirements.
• Performs database re-organizations as required to assist performance and ensure maximum uptime of the database. Puts standards in place to ensure that all application design and code is produced with proper integrity, security and performance.

Environment: Oracle 11gR2, Banner 8X, Oracle 11gR2 and Oracle Fusion Middleware