PROFESSIONAL SUMMARY:

• me have over 11 years of experience in database management systems administration for Banking and Telecom applications, expert at developing and maintaining database, wif strong background of working on high - end servers. me would like to establish a fulfilling proactive career and assume ever increasing responsibility in teh course of time.

• Oracle 10g certified professional having 11+ years of experience wif Relational Databases like Oracle, MySQL, PostgreSQL and MS SQL server and No-SQL database like Mongo DB.
• 5+ years of experience in PostgreSQL Database configurations, Administration, performance tuning, Replication, capacity planning and production support.
• 11+ years of experience in Oracle Database Administration, installation, upgrade & migration, backup and recovery, performance tuning, health check, database security, development, capacity planning of database and 24x7 production support.
• 11+ years of extensive experience in Database Performance tuning, Backup and Recovery.
• 11+ years of experience as Banking and Telecom Database Administrator. Handled very large database (over 4 Tb).
• 11+ years of in depth in different flavors of UNIX such as HP-UX, Solaris and Linux.
• Good at implementing periodic data archiving and purging strategies.
• Self-motivated, organized individual wif strong decision making abilities and a dependable, conscientious approach to assure accuracy for assigned tasks.
• Ability to prioritize and complete multiple tasks under tight deadlines.
• Strong interpersonal and communication skills.

TECHNICAL SKILLS:

DBMS: Oracle database 11g/ 10g/ 9i, MySQL, PostgreSQL 9.5/9.6, PostGIS 2.2/2.4, CitusDB, MS SQL server and Mango DB

Database Machines: Oracle Sun Exadata X3, Oracle Sun Exadata X5-2

Operating Systems: Sun Solaris, IBM AIX,HP-UX, Oracle Linux, RHEL and Windows Server 2003/ 2008/ 2010

Storage Technologies: EMC VNX 5200/VNX 5400, IBM D-8700/D-8300, OCFS2, Oracle ASM

Virtualization Technologies: VMware, V Sphere, Oracle Virtual Machine

Clustering Technologies: Oracle Real Application Clusters (RAC), Oracle Cluster ready services (CRS), Transparent Application Failover (TAF), Oracle Cluster File System (OCFS), VERITAS CFS (VCFS)

DR Technologies: Oracle Data guard and Oracle Streams

Replication Technologies: Oracle Streams, Oracle Multi master Replication and Materialized Views,Slony II Replication

Backup and Recovery Tools: RMAN, Flashback, Legato Networker, Net backup, HP Omni-DB

Tools: and Utilities: OEM, SQL Trace, Explain Plan, Tkprof, Statspack/AWR, Oracle Advisors, TOAD, Grid control, Spotlight, Import & Export and SQL Loader utilities etc

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Lead teh management and database administration of data warehouses for MHVRA survey study on PostgreSQL and PostGIS databases.
• Lead teh development, deployment and administration of databases for multiple supporting applications at DDMA offices in all districts of Punjab.
• Implemented Slony II Replication between PDMA primary and DR databases for high availability.
• Provided database, application support and administration for PostgreSQL databases on Linux platforms, that includes production systems and high volume high demand testing environments.
• Designed and implemented comprehensive PostgreSQL database/backup recovery strategies and solutions by utilizing Pgdump and Pgagent.
• Maintained and administered teh spatial data in PostGIS and pictures data in PostgreSQL
• Capacity planning by collecting performance data over a period of time, performing correlation and analysis for diagnosis, prevention of problems as well as planning for teh future.
• Developed PLpgsql blocks, Programs, Procedures and created Database schema objects like Views, Triggers, Functions, Types and Materialized Views to perform certain critical application tasks.

Confidential

Assistant Manager DBA

Responsibilities:

• Involved in Implementation and Deploymentprojects that includes infrastructure
• Hardware/software and Mobile Financial Proprietary System ‘i8Microbank’ and integration
• Applications
• Provided database, application support and administration for Oracle and PostgreSQL databases on major OS platforms, that includes production systems and high volume high demand testing environments.
• Designed and implemented comprehensive Oracle database backup/recovery strategies and solutions by utilizing RMAN wif EMC networker.
• Setup 3 node Citus DB cluster wif 1 master and 2 worker nodes to create shards of large PostgreSQL schema for load balancing and scalability.
• Ensure smooth operation, user accessibility and 99.5 percent uptime for all Business Critical in a Data Center environment.
• Capacity planning by collecting performance data over a period of time, performing correlation and analysis for diagnosis, prevention of problems as well as planning for teh future.
• Developed PL/SQL blocks, Programs, Packages and created Database schema objects like Views, Triggers, Functions, Types and Materialized Views to perform certain critical application tasks.

Confidential

Senior Database Administrator

Responsibilities:

• Implemented (MAA) Maximum availability architecture using oracle 10g R.2 RAC and Oracle
• 11g R.2 Data guard and Oracle 10g advanced Replication.
• Implemented backup and recovery procedures for Oracle databases and backup test plans.
• Implemented database security policy.
• Created, maintained and refreshed required Oracle instances/databases for development/test and production environments.
• Monitored error log(s), database and log storage, user activity and resource utilization of production, staging and development environment.
• Monitored system resources of database servers to assure production systems met availability requirements and hardware enhancements were scheduled in a timely fashion. provided expert assistance in setting up instances, tablespaces, tables, indices, triggers and views. in conjunction wif consultants/programmers/analysts, defined new objects or modifications to existing objects. provided expert assistance in SQL statement tuning to improve performance. dis includes, but is not limited to, re-writing SQL statements and optimization of PL/SQL Packaged applications.

Confidential

Database Administrator / Dotnet Developer

Responsibilities:

• Install and configure Database as of Oracle’s Optimal Flexible Architecture (OFA) at Windows
• XP, Windows Server 2003 and Red Hat Enterprise Linux 5 for teh entire network.
• Creating database for OLTP systems.
• Enabled teh archive log mode.
• Data movement through EXP/IMP, data pump utilities and database templates and SQL Loader.
• Troubleshooting Oracle Connectivity and performance issues.
• Provided remote assistance to other stations by connecting remotely through WAN or over
• Telephone.
• Implemented RMAN Backup and Recovery Strategies.
• Managing storage and schema objects.
• Reorganized schema objects and rebuilding indexes.
• Using advisors me.e. SQL advisor, Segment Advisor and Memory advisor to tune instance and teh SQL.
• Testing and implementing various backup and disaster recovery strategies.
• Successfully restored and recovered teh database several times including block media recovery, lost control file and inconsistent control files.
• Successfully implemented Oracle Streams Hub and Spoke data Replication environment. All teh network databases share data over WAN through teh HUB (teh central Sever). Teh HUB contains all data of teh company; whereas teh spokes (Station Servers) contain data only belonging to their station. Used tags and subset rules to achieve dis
• Managing and monitoring teh streams capture, propagation and apply processes.
• Avoiding any data conflicts by using conflict handlers.