Database Administrator Resume
Pittsburgh, PA
PROFESSIONAL SUMMARY:
- 6+ years of experience as Oracle and PostgreSQL Database Administrator. I have worked on Oracle 12c, 11g, 10g and PostgreSQL 9.x,
- 10 and 11 versions, running on Linux and Windows Platforms. I Possess strong analytical and problem - solving skills, self-motivateddetail-oriented, adaptive, team player with excellent verbal and writing communication skills and very good in documentation.
- Installing and Configuring PostgreSQL from source or packages on Linux/windows machines.
- Initializing a PostgreSQL Cluster and Configuring postgresql.conf file .
- Carrying out Postgres upgrade including Minor and Major Version Upgrade using Pg Upgrade.
- Experience supporting a mission-critical database environment with 24x7 On-Call Support including weekends .
- Install, configure, test, monitor, upgrade, and tune new and existing PostgreSQL databases.
- Implementing PostgreSQL backup and recovery (Logical and Online).
- Setup and maintenance of PostgreSQL master-master, master-slave clusters utilizing streaming replication.
- Experience in administering large, multi-terabyte PostgreSQL databases.
- Working knowledge of Greenplum database.
- Planned and performed DB Patching.
- Data migration while upgrading PostgreSQL database versions ranging from 9.x to 11.
- Performing Postgres schema management, database sizing, maintaining privileges.
- Proactive in updating the latest security patches to database, provided by PostgreSQL open source community.
- Experience with DB clusters stored in a common file system location, Mapping using symbolic links from designated Tablespaces.
- Strong understanding of Postgres configuration including vacuuming, user/role permissions and partitioning.
- Experienced in working with Pg Barman to centralize all backups.
- Experience in security access control, testing, configuration management, version control, highly available web applications.
- Configuring PostgreSQL Streaming Replication and Pgpool for load balancing. Managing the monitoring tools for better performance like PgBadger, Grafana and Nagios.
- Creating and Maintaining PostgreSQL users, roles, database objects on both AWS and on-prem environment.
- PostgreSQL migration between releases and migrating from Oracle to PostgreSQL.
- Daily log analysis using pgbadger tool and query tuning.
- Monitoring the bloat repot on every table and performing maintenance with minimal downtime.
- Integrated backup and recovery using pgbackrest.
- Experience in writing the pg dump and pg restore scripts using parallel dump and restore methods for automation .
- Configuring the backup jobs on customer system. Experienced in performing PITR.
- Optimize postgresql.conf for performance improvement. Review all PostgreSQL logs for problems.
- PostgreSQL HA with repmgr.
- Configuring database auditing on Enterprise DB by enabling edb audit* parameters in the postgresql.conf file.
- Extensively Used Explain, Explain Analyze and pg advise index to analyze and optimize the performance of queries.
- 24x7 production and critical Oracle database support, including RAC, Goldengate and Data Guard for High Availability solutions.
- Troubleshoot and resolve slowness or performance issues with extensive investigation and follow-up with respective application teams with RCA and proposed solutions.
- Tune and Optimize application code to adhere to SLAs.
- Involve in meetings with top IT management to discuss complex platform migrations.
- Lead upgrades/migrations/patches with complete action plan and tested fallback plan.
- Experience in oracle 10g features:10g RMAN, Data pump, FlashBack Technology and ASM.
- Highly experienced in performance monitoring/tuning/troubleshooting using tuning utilities like STATSPACK, TKPROF, AWR, ADDM and EXPLAIN PLAN
- Expertise in implementing data refreshes (at database, schema & table level) using RMAN utility, Data pump and conventional Export/Import.
- Experience in LOGICAL BACKUPS and Database migration tools with DATA PUMP, Export/Import and Transportable Tablespaces.
- Extensive experience in RMAN (full/Incremental backups) and traditional hot/cold backups.
- UNIX shell scripts for hot backups, SQL*Loader, export and import of database.
- Experience in UNIX shell scripting, automating CRON jobs.
- Implementing 2-node RAC and Installing oracle 11gRAC with ASM and OCFS2 file system.
- Resolve lock/latch and resource contention issues during production hours.
- Strong skills in applying security patches using runInstaller and Opatch utilities.
- Highly experienced in implementing Oracle's Transportable Tablespace (TTS).
- Knowledge of Database Recovery Techniques and implementation of those recovery techniques to ensure business continuity.
- Working Knowledge of Oracle Application Express (Oracle APEX).
- Database replication using Snapshots, materialized views and import/export utilities.
- Expertise in maintaining Database Security using auditing.
- Proficient in SQL, PL/SQL, Stored Procedures, Functions, Cursors and Triggers .
- Created Oracle Wallets and implemented Tablespace level TDE security.
- Working knowledge of Oracle Exadata Machine.
- Knowledge of database migration from Oracle on-prem to AWS (Aurora PostgreSQL).
- Working knowledge of SQL Server Database structure, features and functionality.
- Using Explain Plan, Oracle hints and creation of new indexes to improve the performance of SQL statements.
- Working knowledge of system management languages like Chef and Ansible.
TECHNICAL SKILLS:
OPERATING SYSTEMS: HP, AIX, Solaris, Red Hat Linux RHEL 5.x, Centos 7 and Windows Server.
RDBMS: Oracle 18c/12c/11g/10g, PostgreSQL 9.x/10/11, MS SQL Server 2012/2014
LANGUAGES: SQL, PL/SQL, T-SQL, PL/pgSQL and Bash Shell Scripting.
SOFTWARE/ APPLICATIONS/ TOOLS: DBCA, DBUA, Recovery Manager (RMAN), Oracle Enterprise Manager (OEM), PostgreSQL Enterprise Manager (PEM) OEM Grid Control, Oracle Data Guard, Oracle Management Service (OMS), Real Application Clusters (RAC), ASM, SQL Navigator, TOAD, Putty, WinSCP, Mobaxterm, SQL developer, Data Pump (expdp/impdp)SRVCTL, SQL*Plus, SQL* loader, pgAdminIII, PgAdmin4, SQL Shell (psql), pgbouncer, pgbackrest, pg dumppg dumpall, pg Basebackup, pg rewind, pgbadger, pgpool, Cluster Control, etc
TUNING TOOLS: SQL TRACE, TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM, RETRACE, EXPLAIN ANALYZE, PEV etc.
WORK HISTORY:
Confidential, PITTSBURGH, PA
Database Administrator
Responsibilities:
- Knowledge and hands-on experience with service offerings from AWS.
- Experience in working hands-on with AWS inside production environments.
- Database migration from Oracle on-prem to AWS (Aurora PostgreSQL).
- Capture and share best-practice knowledge amongst the AWS solutions architect community
- Tune auto vacuum parameters to ensure up to date table stats and reclaim space consumed by dead tuples.
- PostgreSQL migration between releases and migrating from Oracle to PostgreSQL.
- Responsible for backup, recovery and upgrading of PostgreSQL databases.
- Removing the Index bloat Concurrently to improve the performance.
- Scheduled maintenance activities like vacuum, vacuum analyze to improve the query response time.
- Maintained custom vacuum strategies at table and database level.
- Responsible for performing regular maintenance activities such as Vacuuming, reindexing, archiving etc.
- Moving Data with PostgreSQL using Tools such as PgAdmin4, Pg Dump and PEM.
- Scheduling pg dump and pg restore scripts for every day dev and test server refresh as per apps team requests.
- Setting up Cron jobs for proactive monitoring, automatic database backups, including PITR backups.
- Kept up to date with PG security patches, and major upgrades from 10 to 11.
- Query optimization and troubleshooting.
- Installed and configured Object level replication like Slony and pglogical.
- Installed and configured connection pooling tools like Pgbouncer and pgpool.
- Installed and monitored PostgreSQL database using the standard monitoring tools like Nagios.
- Configured log analyzation tools like pgfouine and pgbadger.
- Installed and configured Oracle 11g and 12c in UNIX/LINUX (RHEL) and Windows platforms.
- Upgraded Standalone and RAC databases and grid infrastructure from 11gR2 to 12cR1.
- Worked New Features on 12c databases such as recovering tables, masking the fields, using advanced optimization parameters for good performance of 12c Databases.
- Experienced in troubleshooting RAC databases and engaging with application team for gaining performance enhancements for application in clustered environment.
- Responsible for Performance Monitoring and analysis of 11gRAC with AWR (Automatic Workload Repository) reports and ASH (Active Session History).
- Provided support for Oracle RAC, including applying patches, performance tuning, Backup and recovery issues with RMAN, trace analysis, service creation for the apps to fail over, cluster and system management.
- Configured SCAN as a cluster alias for load balancing and as a client connection failover mechanism.
- Experienced with ASM, adding, deleting disks to the disk group.
- Supported development teams with a database related issues and handled the critical issues like network failures and ASM DISK group errors and node failures in the RAC cluster.
- Applied PSU on standalone TEST environment using OPatch and same PSU (Grid and RDBMS Patching) on production cluster using OPatch Auto.
- Involved in datacenter migrating large size database in multiple platform.
- Generated AWR (Statspack), ADDM, Explain Plan, TKPROF, SQLTRACE, ORADEBUG reports for Performance tuning and used new tools of 12c for security purpose.
- Experienced in cloning the non-multitenant container database to pluggable database in 12c using the PDB Metadata clone, PDB Remote Clone and PDB Snapshot cloning feature.
- Have implemented two type of standby databases supported by Data Guard, logical standby and physical standby databases in 11gR2 on two node RAC and automized scripts to delete archive logs that already applied to standby.
- Performed Hot/Cold Backup and Cloning of databases using RMAN with VERITAS Net Backup and Comm vault.
- Constantly monitored the performance (V$ dynamic performance views at peak load) of the Databases and viewing Alert log files & Trace files.
- Experiencing in Installing OEM 12c Cloud Control and upgrading the 11g management agents to 12c agents.
- Migration of databases to 12C from Oracle 10g&11g.
- Also worked on Network data encryption to improve the security and implemented SSL wallet to secure the connections.
- Database Services creation for distributing the applications across multiple nodes and extensively used all command line utilities SRVCTL, CRSCTL, ADR and ASMCMD.
- Redefinition of tables using DBMS REDEFINITION, partitioning the tables in the production, re-defining the columns data types, and moving the LOBS to different tablespace.
- Scheduled RMAN backups, purge jobs, Maintenance Jobs using DBMS JOBS, DBMS SCHEDULER and Crontab.
- Designed and implemented different backup strategies like Cold, Hot, RMAN with Flash Recovery Area and Logical Backups - EXPDP/IMPDP.
- Handled Chained Rows and Row migration and solved the database performance issues.
- Implemented and enforced security for all of the Oracle Databases; the three basic security tasks: authentication, authorization, and auditing.
- Generated Statspack/AWR reports using OEM 12C from Oracle 11g database and analyzed the reports for Oracle wait events, time consuming SQL queries, tablespace growth, database growth.
Confidential, CHICAGO, IL
Database Administrator
Responsibilities:
- PostgreSQL administration: installation, configuration, tuning, backup Cron jobs, replication for many small database server instances.
- Integrated load balancing using pgpool2.
- Debloating tables/indexes, freezing tuples, analyzing tables, tuning queries, pgbadger customizations.
- Minimum down time major migrations with pglogical.
- Configured and Customized the configuration of PEM ( PostgreSQL Enterprise Manager) to monitor and tune the performance of the db servers.
- Proactively tuned the memory related parameters in postgresql.conf file such as effective cache Size, shared buffers and several other parameters.
- Cloned/Migrated databases using RMAN, Data pump and traditional export/import utilities in Oracle 11gR2.
- Implemented recovery strategies whenever required and successfully recovered databases in case database crash, media/disk failures by using RMAN.
- Experienced in Identifying performance bottlenecks on high volume transaction systems, analyze SQL statements and design indexes to improve response of queries.
- Used Log dump utility, Defgen utility in Golden Gate environment.
- Installed oracle 11g Goldengate in dev, test, prod environment on RHEL 5 platform.
- Supported in Performing Golden Gate configuration, administration, installation, also configuring pumps and managing trail files by purging old extract files and log files.
- Troubleshooting Golden Gate using GGSERR.LOG and log dump utility.
- Replication Using Golden Gate for multiple extracts and replication and mapping, Great understanding and usage of advanced parameters in Golden Gate.
- Responsible for Installation and upgrading of Golden Gate 11.2.1.0.1 to Golden Gate (v 12) 12.1.2.0.0.
- Automated monitoring of Golden Gate process and heart beat monitoring.
- Scheduling the Physical backups (hot & cold) in Crontab using RMAN utility and monitoring the scheduled jobs.
- Used SQL trace, TKPROF, explain plan utilities for optimizing and tuning SQL queries.
- Maintained the data integrity and security using integrity constraints and database triggers.
- Performed database re-organizations as required to assist performance and ensure maximum uptime of the database, implement SQL access and tuning advisors’ recommendations.
- Provided 24X7 support for all the production and development databases.
- Highly experienced in implementing Oracle's Transportable Tablespace (TTS) feature using Data Pump, Export/Import (Oracle 11g, 10g) allowing users to quickly move a user Tablespace across Oracle databases.
- Expertise in implementing data refreshes (at database, schema & table level) using RMAN utility and Data Pump, conventional Export/Import of Oracle 11g, 10g.
- Successfully performed migrations from Oracle 10g to 10gR2 RAC Database.
- Successfully upgraded the databases from 11g to non CDB 12c.
- Successfully migrated 12c Non CDB databases to pluggable databases.
- Constantly monitor the performance (V$ dynamic performance views at peak load) of the Databases and viewing Alert log files & Trace files.
- Performed space management, capacity planning, disaster recovery and overall maintenance of the databases.
- Implemented and maintained Oracle 11g Data Guard/standby databases for fail-over purposes.
- Implemented Active Data guard, creating both Logical and Physical Standby databases in 10g, 11gRAC& 12C environment for the Production databases.
- Configured and managed Data Guard extensively for Production databases of sizes ranging from 50GB to 8TB.
- Worked extensively with Physical Standby database, troubleshooting, switchover and switchback using Data Guard Broker and manually as and when required.
- Successfully performed data replication using Materialized views and Oracle Streams in Oracle 10gR2.
- Implemented Oracle TDE to provide transparent encryption of stored data to support submission efforts with release of Oracle 11g R2.
- Evaluated releases of Oracle and its tools, and third-party products to ensure that the site is running the products that are most appropriate.
Confidential
Junior Oracle Database Administrator
Responsibilities:
- Installation of Oracle Database and Oracle products.
- Cloning/duplicate of database with RMAN and user-managed (hot/cold) backups.
- Monitored database performance and database operation to prevent downtime and slowness of the services.
- Installed patches and fixes in the databases.
- Responsible for Creating Users, Groups, Roles, Profiles and assigning the users to groups and grant necessary privileges to the relevant groups.
- Used to run scripts to check the status of databases such as growing table sizes, extent allocation, free space, used space, fragmentation etc.
- Writing SQL scripts to monitor database performance.
- Duplicating Tablespaces and Databases from Production server to Test server as per customer requirement.
- Outlined standards in place to ensure that all application design and code is produced with proper integrity, security and performance.
- Data loading using SQL*Loader, Data Pump and export/import utility to the payroll system.
- Helped with scripting up monitoring jobs for alert log, and space alerts.
- Performed imports of database tables in our dev/qa environments.
- Troubleshoot dev/qa issues with connectivity and interacted with tester/developer in resolving issues.
- Scripted and tested out hot backup in dev environment to be reviewed and used in production in support of the senior dba.
- Assisted Development DBA in writing and tuning SQL scripts.
- Work with application developers in order to assist in modifying the database structure as necessary.
- Implemented Backup/Recovery Strategies.