SUMMARY:

• 7 years of hands - on experience as an Oracle/ PostgreSQL Database Administrator who is passionate and driven to help organizations meet their goals and obtain full value from their technology investments.
• Experienced supporting full system development life cycle. Worked with 10g, 11g and 12c databases and PostgreSQL administration.
• Having good experience in Database Administration for Production support, Installation, Configuration,
• Upgrades, Patches, Migration, backup and recovery, Cloning databases, Auditing, Space management and security.
• Established strong relationships with customers, vendors, and team members.

SKILL:

Database, Sql server, Mysql, Oracle, Oracle 10g 11g, 12c, Pl/sql, Postgresql, Sql, Linux, Red hat, Shell scripting, Unix, Rman, Amazon web services, Python, Ruby, Rails, Ruby on rails, Scripting, Storage management, DBA, Oracle Dba

TECHNICAL PROFILE:

Databases: Oracle 10g/11g/12c, Real Application Cluster (RAC), Data guard, MYSQL, SQL Server and PostgreSQL Database.

Cloud: Amazon Web Services (EC2, Route53, S3, RDS, IAM, Data pipeline, Cloud Watch)

Operating Systems: Linux / UNIX, Red Hat Enterprise Linux, Oracle Linux, Ubuntu, Windows Server 2012/2008R2

Hypervisors: VMWare, VirtualBox

Networking & Protocols: Oracle net, TCP/IP

Programming Languages: SQL*PLUS, PL/SQL, Bash Shell Scripting, Python, Ruby on Rails.

Software Applications/Tools and Utilities: Oracle Enterprise Manager(OEM), Recovery Manager(RMAN), TOAD, TKPROF, Data pump Migration(Export & Import), Procedures, Backup and Recovery Performance turning, SQL*Loader, Real AWR, ADDM, NETCA, NETMGR, DBCA, DBUA, SQL Developer, Automatic Storage Management (ASM) Putty,pgAdmin4, PostgreSQL Enterprise Manager(PEM).

Software: Service Now, BMC Remedy, Contractual 8x8, Serene Business Manager, Confluence, Jira

WORK EXPERIENCE:

Oracle DBA/ PostgreSQL DBA

Confidential, New York, NY

Responsibilities:

• Maintained detailed technical documentation of Database architecture and modeling as per business requirement.
• Provided technical assistance for preparation of shell scripts for task automation.
• Good working knowledge of DB performance monitoring tools.
• Execute established administrative procedures and controls necessary to ensure availability of the applications to its users.
• Monitoring of automated daily scheduled backup of PostgreSQL Database from AWS RDS.
• Schedule monthly Data pipeline to extract data from legacy environment to certify environment.
• Fix issues of Page breaking for firms and assigning Business opportunist to District offices on applications.
• Perform Changes to update Users locked account, password changes or business types.
• Worked with business analysis to determine changes to business annual reviews for customer’s s.
• Ability to proactively identify, troubleshoot and resolve live database systems issues.
• Knowledge of disaster recovery principles and practices, including planning, testing, backup/restore.
• Hands-on experience on database administration, backup recovery and troubleshooting in co-location environments.
• Ability to thrive in a fast-paced, deadline-sensitive environment.
• Perform database monitoring to ensure scheduled automated procedures run successfully.
• Experience in SQL, PL/pgSQL, including stored procedures, functions, triggers, and views.
• Knowledge of database design principles, query optimization, index management, integrity checks, statistics and isolation levels.

Oracle DBA/ PostgreSQL Database Administrator

Confidential, Saddle River, NJ

Responsibilities:

• Ability to proactively identify, troubleshoot and resolve live database systems issues.
• Experience in PostgreSQL Database Performance and statement turning.
• Disaster recovery- Full/PITR for (Hot/Cold/Snapshot)
• Ability to proactively identify, troubleshoot and resolve live database systems issues.
• Experience installing, configuring and maintaining of PostgreSQL Database environments
• Set up multiple Postgres database environments on (dev, test, stage, prod).
• Write SQL scripts for migration of data from Oracle to PostgreSQL, MYSQL to PostgreSQL
• Create documents regarding database setup and share with extended teams.
• Work with database engineers and application development teams to review database architecture and data model.
• Installing and Configuring PostgreSQL from source or packages on Linux machines
• Installing and monitoring PostgreSQL database using the standard monitoring tools like PostgreSQL Enterprise Manager.
• Scheduling daily Point in time recovery (PITR) to the development environment for proper product testing.
• Setup and maintenance of Postgres master-slave clusters utilizing streaming replication
• Migration of Oracle and MYSQL Database to PostgreSQL Platform using tools like Ora2pg for Oracle Database and pgLoader for MYSQL Databases.
• Migrated and created Materialized views, DDL Statement, Functions, triggers, procedures and sequences from Oracle and MYSQL to PostgreSQL in a timely fashion.
• Experience with high availability implementation Experience with designing database schemas, writing DDL and DML, database types, user-defined types like domains, functions, indexes, triggers, and rules.
• Ensure night cron jobs for backups, re-Indexing & vacuuming & materialized views executed properly on 24/7/365 high availability Postgres production and development databases.
• Patch, Upgrade and keep the PostgreSQL DBs current.

Oracle/ PostgreSQL Database Administrator

Confidential, Paso Robles, CA

Responsibilities:

• Planning, installation, configuration, management and troubleshooting of PostgreSQL 9
• Configure pgBouncer to integrate connection pool between Database Server and Clients connections.
• Setup Session User or Roles and assigned privileges to them. Developed scripts for various activities in the PostgreSQL Database Server.
• Writing scripts to monitor database performance and Disconnect Idle Connections
• Setup Database Replication from Master/Slave. Monitor Database Activities using pgAdmin4, Postgres Enterprise Manager (PEM).
• Developed UNIX shell scripts for various tasks such as monitoring, backup, maintenance, etc.
• Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 12c Cloud Control.
• Upgraded and applied PSU/CPU and one-off patches to Oracle binaries in the development environment and production environment using Opatch utility.
• Create and manage documentation on the configuration and support of the Oracle databases.
• Ability to proactively identify, troubleshoot and resolve live database systems issues.
• Knowledge of disaster recovery principles and practices, including planning, testing, backup/restore
• Hands-on experience on database administration, backup recovery and troubleshooting in co-location environments.
• Ability to thrive in a fast-paced, deadline-sensitive environment. Responsible for configuring, integrating, and maintaining all Development, QA, Staging and Production PostgreSQL databases within the organization.
• Responsible for all backup, recovery, and upgrading of all of the PostgreSQL databases.
• Monitoring databases to optimize database performance and diagnosing any issues.
• Develop, implement, maintain policies and procedures and document database architecture to ensure the security and integrity of the databases.
• Implement data models, database designs, data access, table maintenance and code changes together with our development team.
• Experience in code migration, database change management through various stages of development life cycle.
• Providing response for all system / database issues on 24 x 7 schedules responding to critical events and situations outside normal work hours.
• Work with development and operations teams to tune production queries for optimal performance.
• Implement and monitor replication for high availability and disaster recovery scenarios.
• Review new database schema changes.
• Monitor and manage database indexes for optimal performance. Automate the configuration management of database and Big Data systems.
• Performing schema management, database sizing, maintaining privileges.

Oracle Database Administrator

Confidential, Charlottesville, VA

Responsibilities:

• Provide administrative database security role by protecting the database, creating and managing users.
• Provide system management role by troubleshooting, reviewing and monitoring database performance.
• Maintained various databases ranging from 300GB to 3TB. Regularly performed Database Refresh using RMAN Duplicate.
• Performed series of database refresh from production to test. Performs general DBA duties (install software, create databases, table spaces, add redo log files.
• Managing storage & work closely with Sr. DBA on capacity planning and performance tuning
• Performs daily database backup of development and test environments, use production data to refresh development and test schemas for testing
• Excellent troubleshooting skills. Performance tuning and monitoring. Identify and make recommendations per database performance issues Knowledge of managing Oracle on Windows
• Knowledge of database design. Use DBCA to create and DBUA to upgrade Oracle databases Prepare documentation for DBA department
• Implements/maintains database security with roles and system privileges Experience working in a help desk and call center environment.
• Demonstrate ability to quickly diffuse heated customer situations. Excellent troubleshooting and logical problem- solving skills.
• Creative ability to solve unusual or difficult problems when logical methods have failed. Demonstrate ability to meet deadlines and set priorities.
• Strong communication and interpersonal skills. Ability and desire to learn new technologies quickly.