SUMMARY:

• Over 10 years Oracle DBA experience in the industry.
• Oracle Exadata Trained Certified Professional ( OCP ) DBA (highest scored 98% in North America in OCA exam) with extensive qualifications including Oracle 12C/11g/10g RAC, EM grid control, data analysis, modeling, designing, data formatting, loading, database create and managements (backup & recovery, security maintenances), infrastructure development and administration with multisite networks, hardware/software acquisitions and configurations.
• IT professional, proficient to analyze, design, develop, implement mission critical database and integrate complex business systems that provide real time business solutions and increase organizational efficiencies/productivities.
• Master Degree in Computer Science & Engineering and having multi - tasking capabilities and enable to work in-group and independently.

TECHNICAL SKILLS:

Database: Oracle 12c, 11gR2/10gR2/9i, IBM Netezza, SQL Server 2014/2012/2008 R, PostGreSQL10.x, SAS

Oracle Tools: PL/SQL, Oracle SQL* Plus, Oracle RAC(12C/11gR2),OWB,OLTP/OLAP, Active Data Guard, ASM, Oracle E-Business SuiteR12/SOA,Oracle XML Publisher),DB Modeling Tools (MS-Visio, Toad, Erwin, Designer, Oracle Developer suit6i), DBMS Tools ( Toad Oracle 11.6, Oracle SQL Developer, DB Artisan9.X), EM Console (12C/11gR2), Backups & Recovery (RMAN), Monitoring Tools ( OEM13C, Confio Enterprise Ignite8,, Fog Light, Oracle Golden Gate 12C/11g, Idera SQL diagnostic Manager) Ticketing Systems( BNC Remedy7.X/Magic, Service Desk), Connectivity ODBC/JDBC.

ETL Tools: IBM Informatica (Power Center Repository Manager, Designer, Workflow Manager and Workflow Monitor), ODI (Oracle Data Integrator), Oracle SQL* Loader, Fast Reader Loader, Data Pump, Cross Platforms (Transportable Database/Tablespace), SQL Server (SSIS, SSRS).

Platforms: Sun Solaris (5.x), Redhat Linux Server, AIX, HP UNIX, Oracle EXADATA,VM Ware/Citrix XenApp 5.0, Windows NT, Scripting (Perl /csh), Others (JBoss, Java, C#, .NET, HTML, ASP, IIS, Apache, Tomcat, Oracle Apex 5.0, Application Middle ware/WebLogic, AD/LDAP). TCP/IP, DNS, DHCP.

PROFESSIONAL EXPERIENCE:

Confidential, Alberta

Database Administrator

Responsibilities:

• Providing day to day Confidential production databases operational supports (Oracle 12C/11gR2 and SQL Sever 2016/2008R2) and activities as per business requirements.
• Performing RDBMS software (Oracle 12c/11g, WebLogic 10.3.6, SQL Sever 2014) installations, configurations, setup backup/recovery and disaster recovery (Data Guard) systems in all three environments(prod/test/dev) as designed by the organization.
• Maintaining existing user accounts, profiles, roles, assigned privileges on the schema objects.
• Run batch jobs and stored procedures and packages as per developer request.
• Participating sql scripts/codes reviewing and recommending developer for best practices.
• Upgrading existing Oracle databases from 11GR2 11.2.0.4 to Oracle 12C 12.2.0.1
• Appling oracle Middle Tier Applications server (WebLogic 10.3) released patches as per vendor recommendations.
• Monitoring databases performance using (OEM13C) and database daily backup/recovery processes, data security/integrity, disk space requirements and database server performance.
• Change management control processing, trouble shooting, bugs fixing on running databases /applications when needed.
• Provided on call support ( 24/7 On Call ) in production database environment.

Confidential, NC

Oracle DBA / Exadata (Team Lead)

Responsibilities:

• Performed installations and configurations 12c/11gR2 Oracle/ MS SQLServer 2014 software under oracle Exadata (Xn-2, Full Rack/ non Exadata (MS SQL Server 2014) environments.
• Provided day to day ' Confidential ' Enterprise Databases (Oracle 12C/11gr2 RAC/Non-RAC) and MS SQL Server production supports based on highly transactional systems under Oracle Exadata / Non Exadata platforms.
• Monitored performance of the Exadata components (db servers, cell storage servers, IB switches etc.) as per vendor service level agreement (SLA).
• Created new databases user accounts / profiles, groups, roles, authentications and assigned user privileges on the schema objects.
• Administered all of the database schema objects, including tables, indexes, views, materialized views, sequences, packages and procedures.
• Performed data movements operations from the productions to test and development environment using Data Pump, DB Links, Oracle Golden Gate and other third-party tools.
• Monitored production databases performance and OLTP, OLAP, user connected session activities, locks, latches, alert.log, security threats, and taking actions when it is needed.
• Monitored evening backups logs activities, block corruptions, verified and tested backup pieces using database verify utilities before sending to the secondary storage locations.
• Monitored database tablespaces that use by the specified application users, added additional tablespaces while needed and maintained user’s spaces/quota management policies to run smooth operations.
• Upgraded databases from 11gR2 to 12C, as well as other upgrades from 10gR2 to 11gR2.
• Migrating Oracle 12c/11gR2 databases (cross platforms Sun Solaris 11.3, IBM AIX to Oracle Linux 6.X server, and Oracle Exadata Xn-2 Servers) as per DDRT (Decentralize Database Remediations and Transfer) project requirements.
• Applied vendor recommended oracle update patch sets like quarterly release patches.
• Upgrading existing Oracle WebLogic servers from 10.3.0.X to 10.3.0.6 applying 171017 released patches.
• Installed agents into new databases and added databases into OEM13C monitoring systems to ensure the resources utilized properly.
• Provided on call support 24/7 (Saturday, Sunday) in production database environment.

Confidential, TX

Database Administrator

Responsibilities:

• Worked in ongoing UTSA ‘Oracle Software Implementation Project’ mainly new Oracle Server Software (Oracle 12c version 12.2.0.1) installations, configurations, setup backup/recovery and disaster recovery (Data Guard) systems in two environments(prod/test) as designed by the organization.
• Provided day to day productions database operational supports ( Banner 8.5 /Non-Banner) under UNIX OS (Linux Red Hat 6.0) and Windows MS SQL Server 2014 environments.
• Clustered newly built production database (Oracle 11gR2 RAC on 2 Nodes, ETHOSProject) servers and applied vendor recommended standard patches.
• Created/removed user groups, profiles, roles, assigned privileges, authentications, encryptions and developing scripts for easy database administration.
• Created new batch/cron tab jobs, views, materialized views, synonyms, run stored procedures and packages as per developer request.
• Tuned and tested activities on developer provided sql scripts and recommending for best practices.
• Bugs fixed in running ERP (Oracle Banner 8.5 version) modules to continue smooth operations.
• Updated existing running WebLogic Servers patches (171017.10360 ) using available utilities and techniques (OEM, OPatch)
• Upgraded (In/out place)number of existing oracle 11gR2/10gR2 databases into Oracle 12C and installed agents into new created oracle databases(12c) and adding databases in OEM13C for monitoring purposes.
• Migrated databases / tablespaces under cross platforms policies (Sun Solaris 10 to Linux 5.9).
• Monitored database systems performance using various tools and techniques (OEM13C and Spot Lights) and maintained database backup and recovery processes, data security/integrity, disk space requirements and database server performance.
• Provided ON Call support 24/7 weekends rotational basis.

Confidential, KY

Oracle DBA

Responsibilities:

• Provided day to day Confidential operational Enterprise Production Databases (Oracle 12c/11gR2, IBM Netezza,SAS) and applications supports under all three environments (Prod, Dev and QA) for ongoing business activities.
• Performed Oracle database servers’ software installations, configurations, upgrading (In place / Out place) databases and patching, set up backups, disaster recovery (Active Data Guard) and high availabilities(RAC) of the systems
• Monitored enterprise database systems performance, including running applications, user session activities, long running jobs/queries and managed workloads to ensure the healthy systems and resources are available.
• Performed database tuning activities, codes reviewing, SQL scripts testing, logs analysis; long running query analysis, bug fixing and recommended to release into the production.
• Migrated Oracle database from 10gR2 to 11gR2 and 11gR2 to 12C also migrated 12c non-container to 12C container db.
• Team lead in Confidential Oracle Exadata Migration Project 2017 as one of the technical expertise members, and analyzed migrated database applications performance issues, impacts and initiated changes related to Exadata Infrastructure.
• Implemented Confidential financial Corporate System Data Mart (CSD) development projects, the major tasks were under the project like cloned / created new databases, setup backup/recovery system, designed schema objects (profiles, groups, roles, privileges, tables, views etc.) and scripted for easy DB administration.
• Supported financial CSD running all applications (Daily/Monthly/Quarterly End running critical/noncritical jobs) to make sure jobs/applications run properly and data populated on the target systems, in case of jobs failure or aborts, did research on root cause analysis and fixed the issues.
• Installedand configured Oracle Golden Gate Software and replicated tables data on remoted targeted locations.
• Supported to developers’/business users/ stockholders required data movements processes (including MMIS data - Medicaid/Medicare) from single/multiple partitioned tables and locations under Data Warehouse (WH) distribution policies and agreements using ETL, PL/SQL etc.
• Maintained up to date change control documentations following Confidential operational standards and procedures to establish and formalize database infrastructure administration principles for Oracle, IBM Netezza warehouse appliance and Informatica Power Center Repository etc.
• Performed weekly/Friday night database backups and financial data archiving.
• Provided on call (24/7) days assistance in troubleshooting applications and database infrastructure problems in order to restore business systems that have failed.
• Administered IBM Informatica offered products and applications (Power Center Repository, Designer, Workflow Manager/Monitor, Data Integration Hub etc.)

Confidential, IA

Oracle DBA

Responsibilities:

• Provided day to day operational and technical supports for the databases (prod/dev/qa) and applications issues under Oracle RAC 12c/11g/10gR2 enterprise grid control environments.
• Installed, configured and maintained new created databases (Oracle 12C/11gR2 and SQL Server 2008R2-12R2, Sybase 15.x) required for development and testing purposes.
• Setup vendor recommended databases and applications monitoring tools Oracle 11gR2 Enterprise Manager (OEM), Fog lights and setup database health alert system.
• Setup databases high availabilities and disaster recovery systems such as Oracle 11gR2 RAC (2 Nodes) and Active Data Guard.
• Installed Oracle Golden Gate and migrated/replicated tables data to target sources.
• Monitored performance of the running production databases and OLTP, user connected session’s activities, locks, latches, alert.log, block corruptions, segment fragmentation, security threats, and tune databases when it was needed.
• Performed huge database tuning activities (systems and SQL query) using available tools and techniques such Oracle Tuning Pack, Tkprof, Plan Table, SQL Tracing, Stats pack, AWR,ADDM,
• Applied vendor released critical patches and upgraded database instances as per SLA.
• Planned and implemented databases backup (incremental/differential hot & cold) and recovery (RMAN) systems for all new created databases (test and dev).
• Monitored daily backups logs activities, verified and tested backup pieces using db verify utilities before sending to the secondary storage locations.
• Lead the team members (offshore applications developers) in WF-ICMP applications (Iowa farming mortgages and loans) project deployment and provided project progresses to the project manager during weekly meeting.
• Provided support for ICMP applications, mainly ensure that jobs were running on time and got completed properly, in case of failure or aborts or needed any parameter changes or values all done properly.
• Controlled migrations of all database programs (oracle 11gR2, SQL Server 2008R2/2012R2), especially database changing, data changing and menu changing through the development life cycle.
• Migrated existing old databases (IBM DB2, SQL Server2005, Sybase, and Oracle 10g/9i) to new Oracle 11gR1/R2 database environments using available Confidential provided tools and techniques like Oracle Golden Gate, Oracle SQL Developer, and SwisSQL.
• Initiated change management procedure and released new changes into productions and non-productions database systems environments.
• Implemented database auditing, data security and remediate high-risk violations in production environment.
• Evaluated the vendor released products, tools, and third parties running applications, hardware/software products to ensure that the site was running the products that were most appropriate.
• Administered all of the database objects, including tables, clusters, indexes, views, materialized views, sequences, packages and procedures.
• Scripted and wrote PL/SQL codes, stored procedures, created views, roles, materialized views, various DDL/DML operations to administer databases easily.
• Assisted with the impact analysis of any changes made to the database objects.
• Troubleshoot in the databases and running applications problem fixing.
• Provided on call support (24/7 On Call) in production database environment by rotations.

Confidential, MI

Oracle DBA

Responsibilities:

• Performed installations, configurations and administering databases ( Oracle 11/10g/9i, SQL Server 2012/2008R2 ) server, and setup backup & recovery systems as designed by the organization.
• Provided day to day databases ( Oracle 11/10g, 9/8i, SQL server 2012/2008R2/Sybase15.0PostgreSQL ) operational supports, maintenance and upgraded patches in all environments (prod/dev./test).
• Created/removed user profiles, groups, roles, privileges, authentications, encryptions and scripted for easy database administration (including Sybase user profile).
• Developed the daily/weekly databases maintenance and backup plans (RMAN, IBM Tivoli, and VERITAS) and restoration of all critical systems and data, in terms of using disaster and recovery methods.
• Created huge number of new batch jobs, views, materialized views, synonyms and scheduled those jobs, stored procedures and packages and run them when needed in terms of end user and developer requests.
• Performed scripting, and broken jobs fixing in Oracle/SQL servers UNIX and Windows environments.
• Upgraded database and application servers (WebLogic) patching using available utilities and techniques.
• Migrated databases from DB2, Oracle 8i, SQL server 2000 to Oracle 10/11G using golden gate, SwisSQL, Oracle SQL Developer.
• Provided supports for running oracle application servers (Fusion Middleware11g, Web Logic 10.3servers)
• Monitored database systems performance using various tools and techniques (OEM, Idera SQL Diagnostic Manager), and maintained database backup and recovery processes, data security, data integrity, disk space requirements and provided reports on database server performance.
• Added new node to Oracle 10gR2 RAC and 11gR1 RAC environment (4 nodes).
• Tuned databases and applications and ensured best performance of the systems.
• Provided on call support ( 24/7 On Call ) in production database environment.

Confidential, Alberta

Technology Consultant/Database Support.

Responsibilities:

• Provided 24/7 production databases (10gR2 4 Nodes RAC) support based on highly transactional systems under UNIX (Sun Solaris 5.X)/Windows environments.
• Installed and upgraded of Oracle on Sun Servers and applied patches as required.
• Installed Oracle Enterprise Manager (OEM), added hosts, databases, agents and setup database backup policies using OEM Interface.
• Monitored database performance and tuned running application when needed.
• Involved in data loading using SQL Loader/Informatica and data export/import.
• Performed capacity planning to protect databases resource shortage and running smooth operations.
• Upgraded databases from 10gR1 to 11gR2, as well as other upgrades from databases in 9i to 10gR2.
• Performed data movements from the productions to a test and development environment using Data Pump, data export/import and other third-party tools.
• Problems resolved base on systems generated incoming trouble tickets.

Confidential, Alberta

Oracle DBA

Responsibilities:

• Provided day to day productions database (Oracle 10g/9i) operational supports for IBM clients like ATB Financial and Alberta Oil & Gas companies.
• Performed enterprise database (Oracle 10R2) and applications server (Web Logic 10.3) software installations, configurations, upgrading patches, database management and administrations under various operating systems (Linux, Sun Solaris 5.10/Windows 2005).
• Created user profiles, groups, roles and scripted for easy database administration.
• Approved all productions database designs and schema changes.
• Controlled all migrations (Oracle 8i and SQL Server 2000 to Oracle 10R2) of the database schema objects and ensure the data availabilities.
• Performed daily backup & recovery system (RMAN) and VERITAS.
• Setup databases performance monitoring system tools (OEM 10g Grid Control)
• Monitored database performance tuning and others diagnostic activities.
• Provided On-Call (24/7) technical supports when needed.