PROFESSIONAL SUMMARY:

• An accomplished Database Architect, DBA, Data Modeler, published author with more than 14 years’ experience specialized in the field of Database Administration which includes Oracle 9i,10g,11g,12c, MS - SQL Server 2005,2008,2014 and MY SQL
• Expertise in installation, configuration, upgrades, patches, cloning of Oracle 9i, Oracle 10G, Oracle 11G and Oracle 12C on various platforms like Sun-Solaris, HP-UX, Red Hat Linux, Oracle Enterprise Linux and Windows.
• Proficient in Installation, Configuration of Oracle High Availability features like RAC, DATA GUARD and Oracle Grid Infrastructure on UNIX, LINUX and Windows environment.
• Specialized on fixing Performance and Tuning problems in Oracle database using tools like AWR, ASH, ADDM, SATSPACK, OEM, Dynamic Performance View, EXPLAIN PLAN and DBA scripts.
• Strong experience in Backup and Recovery strategies using RMAN, Export/Import, Data pump, Hot and Cold backups and Created UNIX Shell scripts to automate database operation.
• Experience with Oracle database security administration, configuration and Implementation which includes Oracle Transparent Data Encryption (TDE), Data Redaction, Virtual Private Database, Privilege Analysis, Conditional Auditing, Oracle Audit Vault, Database Firewall and Privilege User Control.
• Experienced in Logical and Physical Data Modeling, and designing online transaction processing OLTP, data decision support DDS, warehouses DW database systems using tools like ER Studio
• Solid understanding of and working experience with Oracle 12c Multitenant (Container and Pluggable) database.
• Proficient in SQL, PL/SQL, T-SQL, Package,Stored Procedures, Functions, Cursors and Triggers.
• Experience in data migration from Oracle to Cloud platform using data pump, RMAN and AWS Snowball
• Over 3+ years of experience in database administration, implementation, analysis, modeling, monitoring and performance tuning SQL Servers 2005,2008, 2014.

TECHNICAL EXPERTISE:

Database administration: Oracle database 12c, 11g, 10g,9i and 8i, Oracle Exadata Database Machine, MS-SQL Server 2005,2008,2014, MYSQL, RAC,RMAN, ASM, AWR, ADDM, Statpack Report, Oracle 10g, 11g, 12c EM, Flashback, Transportable Tablespace, Datapump, Export/Import, DBCA and NETCA, Data Guard, Oracle Stream, Materialized View, Golden Gate,SQL, TSQL, PLSQL, Microsoft SQL Server Management Studio, SSRS

Modeling Tools: SQL Developer Data Modeler, ERStudio Data Architect 17.0,Erwin Data Modeler

Operating Systems: UNIX, Linux, Solaris 10, Windows server

Languages: C++, Java, C#

Development Tools: Oracle Developer (Forms 9i,Report 9i), Java Developer (9i,10g), Oracle Apex, Oracle SQL/PLSQL Developer, TOAD, Oracle Application Server, WebLogic, Apache, Oracle Business Intelligence, Hyperion, JIRA,Citrix, Remote Desktop, PuTTY, HP ALM, WinSCP, TortoiseGit, Lotus Note, Fisheye Crucible, Agile

PROFESSIONAL EXPERIENCE:

Confidential, Jacksonville, Florida

Database Architect/ Lead Database Administrator

Responsibilities:

• Created conceptual, logical and physical data models and entity-relationship diagrams for relational database systems
• Applied data modeling standardization rules to all data models which includes entity naming, element naming, preferred data typing, required metadata, privacy classifications and data masking rules
• Installed and configured Oracle grid infrastructure and ASM for development and test databases
• Installed and configured oracle 12c database which include CDB and PDB databases.
• Performed database consolidation using oracle 12c pluggable database.
• Performed database cloning using RMAN duplicate command.
• Reviewed and tuned complex PL/SQL package code change with development team for harvest proprietary product EYE touch.
• Performed instance tuning, SQL tuning, database tuning using utilities like EXPLAIN PLAN, AWR, ADDM, Dynamic Performance Views and database scripts. 
• Created and developed the database objects like Partitioned Tables, Indexes, Triggers, Stored Procedures, functions and packages.

Confidential, Oaks, Pennsylvania

Database Architect/ Lead Oracle DBA

Responsibilities:

• Installed and configure Oracle database 12c, Oracle enterprise manager, Oracle database 11g, Oracle 11g RAC, ASM & Data Guard, RMAN on various OS Platform like Linux, UNIX and Windows.
• Performed performance tuning activities using EXPLAIN PLAN, STATSPACK, DBMS STATS, Automatic Workload Repository (AWR), Active Session History (ASH), Automatic Database Diagnostic Monitor (ADDM) and SQL Tuning Advisor.
• Performed Database designing, Sizing tablespace, Create database scripts, Reviewing database scripts, Monitor databases, Interact with developers, Oracle Install, Upgrade, 24x7 DBA Production support, Disaster recovery Automate daily jobs, Schema management, Data Pump, Export/import Database, SQL Tuning, Capacity Planning and Managing Users, Storage allocation and Creation of physical database objects from logical model.
• Installation and maintenance of SQL Server 2005,2008,2014 database systems. Managed database backup and recovery, performed performance tuning, maintained database security, created database objects including tables, view, cursor, triggers, stored procedures, indexes, defaults and rule.
• Implemented scripts, object naming convention and coding standards for database code in ongoing project.
• With Strong programming experience, I have implemented code changes in complex PL/SQL Packages, Stored Procedures and Functions, Database Triggers.
• Implemented in-memory option on oracle database 12c for performance of critical database transaction.
• Implemented security administration by creating of roles, data encryption, data redaction, views and granting the necessary object/system privileges for users.
• Performed database consolidation using Pluggable database in Oracle Database 12c.
• Performed Database Backup and Recovery, Database cloning using RMAN and Data Pump.
• Completed migration/upgrade from Oracle 11g to Oracle 12c successfully
• Installed and configure new features of oracle database 12c like container database and pluggable database compliance with cloud computing.
• Working closely with clients, business analysts, server administrators, systems programmers, and application developers to define and resolve information flow and content issues helping to transform business requirements into environment specific databases

Confidential

Lead Oracle DBA

Responsibilities:

• As a Lead Database Administrator with a team of 20 Oracle DBAs, I was responsible for administration of development, production and test Databases at Germany Railway.
• I have made multiple visits to this client during the above period as a key support person related to database administration and database designing.
• Performed upgrades from Oracle 10g to 11g and applied patches. 
• Configuring database entries and monitoring all of the databases using Oracle Enterprise Manager (OEM). 
• Responsible for configuring database memory structure, managing storage allocation, creating user accounts, roles and privileges for DB operations and security maintenance. 
• Monitored OEM alerts, space alerts, alert log errors and performance issues on the production databases.
• Managed multiple standalone MS-SQL Server 2005,2008,2014 instances containing system critical databases.
• Monitored and maintained all MS-SQL Server 2008,2014 subsystems (SQL Agent)
• Ensured backup and recovery processes for all MS-SQL Server 2005,2008,2014 database
• Installed, configured, upgraded, backed up, and monitored MYSQL databases
• Managed appropriate use of free space within tablespaces, reclaimed space whenever possible.
• Performed FLASHBACK features to handle efficient database recovery for human errors
• Hands on experience in developing procedures, functions, packages and triggers using complex PL/SQL.
• Very good experience in development tools like TOAD, SQL Developer, PL/SQL Developer.
• Identify improvement plans and implemented those in the project to enhance the quality of the deliverable
• Contacted Oracle corporation for technical support and patches
• Coordinated/communicated with customer and offshore to manage day to day DBA activities

Confidential

Lead Oracle DBA

Responsibilities:

• Performed data warehouse migration from Oracle 8i to Oracle 10g.
• Design and implemented 2 TB database and storage for data warehouse using materialized view.
• Performed complete multi-master replication with updateable Materialized views.
• Performed regular Backups and Recovery as per Organization Strategy to support the database and Troubleshooting with restoring and recovery.
• Rebuilding of Indexes and managing the table partitions for better performance, maintenance of Oracle Database.
• Experience in Identifying performance bottlenecks on high volume transaction systems. Analyze SQL statements, reorganize database objects and design indexes to improve response of queries.
• Implemented database security by enforcing roles and profile management
• Created the database, tables, tablespaces and data objects, indexes, users and implemented security using data encryption and privilege user control.
• Worked on Planning Database, Sizing table space, Create database, scripts, Monitor databases, 24x7 production support
• Checking Databases Backup and Restore validity periodically, and Data refreshes from Production to Non-Production environment, Creation Duplicate Databases using RMAN Backups.
• Created routines for Daily, Weekly & Monthly partitioning of tables.
• Created/Altered Partitioned tables for large customer related data.

Confidential

Sr. Oracle DBA

Responsibilities:

• Worked in Oracle database 8i, 9i, 10g and 11g and interchangeably across multiple O/S platforms (HP/UX, Sun Solaris, Redhat Linux and Windows 2000+ servers supporting 100s of schemas to prevent and/or fix thousands of production problems.
• Participated in various critical Oracle production database related meetings.
• Worked with both Cost and Rule based optimizer modes in Oracle database instances.
• Managed capacity planning for Oracle instances and advised the company accordingly.
• Managed a database with 60 partitioned tables which was setup to act as a mini data warehouse.
• Used AWR, explain plan for performance related issues.
• Worked on Data transferring with export/import utilities and Data pump and RMAN
• Managed Database Growth and Space management, distributed the tables, redo logs, archived redo logs table partition and indexes on different disks to optimize data retrieval.
• Configuring parameter file to fix sizes of SGA components in conformity to available resources.
• Involved in logical backup using and full/ partial export/import and Data Pump.
• Used SQL Loader extensively to extract data from flat files and loading into the new application.
• Performed database analysis, design, coding, testing and implementation of database structures.
• Worked in creating logical and physical data models for large complex applications and translating logical database models into database design
• Managed replicated databases using snapshots implementing and managing materialized views in Oracle 9i/10g
• Creating Indexes, rebuilding indexes, analyzing indexes to improve the performance of query.
• Creating tablespaces and planning the location of data, index and rollback tablespaces redo log files and control files in adherence to the Optimal Flexible Architecture.

Confidential

Sr. Oracle DBA

Responsibilities:

• Installed, configured and upgrade of Oracle server software and related products
• Documented coding standards, lessons learned, best practices, problem resolutions and quality improvement documentation for POC
• Configured Oracle networking components such as the listener, TNS names and other connection protocols for the Oracle client using NETCA.
• Created Oracle database instances using DBCA to conform to Oracle's optimal flexible architecture (OFA) standard
• Regularly checked ALERT logs to know types of Bottlenecks recorded during if any, and rising to counter them. Managing Redo logs and Data files like adding, renaming and resizing
• Managed Control files like adding, recreating and tracing to physical locations and tracing
• Configured Oracle Enterprise Manager and maintain data integrity, managing profiles, resources and password security
• Created and managed users, privileges and roles
• Documented all security practices and created daily management reports
• Used RMAN to perform full and incremental backups and recoveries
• Managed Production, Development and Test Database in 24x7 environments
• Performed time based incomplete recovery to recover accidentally dropped tables
• Monitored the different memory structures such as shared pool, data dictionary cache, library cache, buffer cache
• Implemented UNDO table space feature of Oracle 9i database
• Performance tuning at database level for the parameters like SGA, PGA, SGA TARGET PGA AGGREGATE TARGET
• Implemented multiple Archive log destinations to archive redo logs to support database recovery
• Analyzed tables, optimized queries and supported development on using cost base optimizer.