SUMMARY:

• Seeking a position in IT where my demonstrated experience in thought leadership, system architecture and design, performance tuning and implementing high availability solutions for various database technologies will be fully utilized.
• Highly accomplished DBA/Database Architect, Data Modeller with in - depth industry experience in designing and managing Oracle and SQL Server databases and leading the team of DBAs and Developers to accomplish the projects on time.
• Proven ability to integrate the data across heterogeneous systems and unify it to create effective business solutions.
• Established project standards, planned and managed risks for successful implementation of several systems and database projects.
• Expertise in installation, migration, upgrading, patching, cloning and maintaining both RAC and non-RAC Oracle 12c/11g/10g databases on Linux, HP-UX, Sun Solaris and Windows environments.
• Expertise in cross platform migration/upgrade of Oracle, MSSQL databases between Unix, Linux and Windows as well as replication, integration of data among databases using golden gate, gateways and mview.
• Expertise in installation, configuration and support of Oracle High Availability solutions such as standby database using Oracle Data Guard and Golden Gate.
• Expertise in implementing best practices in Backup and Recovery. Implemented and tested the Disaster Recovery strategies and prepared documentations.
• Worked on several systems architecture, design and user manuals, and development and integration guidelines for DBAs and Developers including conventions. Prepared and implemented maintenance plans for various databases.

TECHNICAL SKILLS:

• SQL Server 20xx/SSMS/SSIS/SSRS Oracle 12c/11g/10g
• Oracle 12c cloud/11g Grid
• Oracle RAC/Data Guard
• MySQL/MariaDB/PostgreSQL
• Peoplesoft ERP
• SQL profiler
• Database Tuning Advisor
• PerfMon
• SSRS
• DMVs
• SCCM
• Stored Procedures TOAD/SQL Developer
• C/C++/PLSQL/SQL*Plus/SQL*Loader T-SQL/PSQL
• Oracle data pump/exp/imp
• Unix admin shell scripts
• Erwin/ Oracle Designer
• ESRI tools/Oracle Spatial
• Microsoft Project/Share Point Cognos/Data Warehouse tools
• Red Hat and Oracle Enterprise Linux
• SUN Solaris/AIX/HP-UX
• Unix/Unisys/DG-Aviion
• Windows/Microsoft Office/Visio/Outlook/ MSAccess/IIS/PowerShell
• Oracle Middleware/Web Logic
• Maximo/M4/M5/Trapeze VMware/EMC Storage/Backup Exec
• NetBackup TIVOLI TSM Backup server putty Nagios

PROFESSIONAL EXPERIENCE:

Confidential, Cincinnati, OH

Senior Database Administrator

Responsibilities:

• Managing and administration of more than 800 Oracle, SQL Server, MySQL, MariaDB and HP Vertica databases.
• Database Administration for Oracle 11g/12c databases, Installation, Upgrade, Configuration, and Performance Tuning.
• Installation, configuration, performance tuning and maintenance of SQL Server 20xx databases.
• Installation, configuration, performance tuning and maintenance of MySQL 5.x and MariaDB 10.xdatabases.
• Managed projects on change management, growth analysis, capacity planning and efficient notifications.
• Continuation communication with Axcess management, providing recommendation and guidelines towards implementation of better plans bringing more security, high availability and continuation process improvements.
• Monitor heavy loads using Pentaho ETL and Tableau reporting. Continuous SQL plan monitoring and tuning databases.
• Led Disaster Recovery Project, made design and testing plans, successful implementation.
• Involved in heavy automation of daily repetitive tasks, continuous improvement on notification and alerts.
• Continuous work towards improving backup, recovery and disaster recovery solutions.
• Made project plan, scheduling and implementation. Knowledge transfer to peers and dev team.
• Involved in on-call process, and monthly server maintenance with database and server patch application.
• Worked extensively on database, server, application security and audits conforming to InfoSec guidelines.
• Extensive work with AWRs, ASHs, SQLT, Hang Analyze, ADDM reports and bug fixes on databases.
• Extensive work with SQL profiler, Database Tuning Advisor, Perf Mon, SSRS, DMVs, SCCM, Stored Procedures.
• Extensive use of Oracle and SQL Server tools, SQL Tuning advisors, ADDM, AWR, database new features

Senior Database Administrator

Responsibilities:

• Database Administration for Oracle 11g/12c databases, Installation, Upgrade, Configuration, and Performance Tuning.
• Upgraded/Migrated 60+ Oracle databases from 11g to Oracle 12c on Linux VMWare servers meeting project deadlines.
• Upgraded/Migrated 100+ SQL Server databases from 2012 to 2014 on Windows VMWare servers.
• Installation, configuration, replication, performance tuning and maintenance of MySQL 5.6 databases.
• Installation, configuration, performance tuning and maintenance of Oracle 11g/12c and SQL Server 20xx databases.
• Installation, configuration of Oracle RAC, Data Guard and Oracle Golden Gate solutions.
• Worked on logical, physical design and helped developers with data modeling using ERWin r7 and 8.2 tools.
• Worked on change management, growth analysis, capacity planning.
• Monitored heavy dataloads using Informatica. Continuous SQL plan monitoring and tuning on Oracle databases.
• Involved in heavy automation of daily, repetitive tasks, continuous improvement on notification and alerts.
• Continuous work towards improving backup, recovery and disaster recovery solutions.
• Made project plan, scheduling and implementation. Knowledge transfer to peers and dev team.
• Involved in on-call process, and monthly server maintenance with database and server patch application.
• Worked extensively on database, server, application security and audits conforming to InfoSec guidelines.
• Extensive work with AWRs, ASHs, SQLT, Hang Analyze, ADDM reports and bug fixes on databases.
• Extensive work with SQL profiler, Database Tuning Advisor, PerfMon, SSRS, DMVs, SCCM, Stored Procedures.
• Extensive use of Oracle and SQL Server tools, SQL Tuning advisors, ADDM, AWR, database new features.
• Extensive use of V$ performance and monitoring views, Explain Plan, os commands and utilities.

Senior Database Administrator

Responsibilities:

• Database Administration for Oracle 11g Data Warehouse, Oracle RAC, Oracle Data Guard and Siebel databases, Postgres 8.4 databases on Red Hat Enterprise Linux 6.2.
• Extensive analysis and performance tuning of Oracle databases, disk I/O monitoring, identified the bottlenecks and provided solutions, tuned SQL queries, using advance v$ performance views.
• Migrated tablespaces, move tables and indexes to make effective use of Oracle parallel processing capabilities.
• Performed database tuning, make recommendations towards adjusting database properties, changes in initialization parameters, using advance features, index monitoring and optimization.
• Learning Postgres database administration, provided assisting DBA support for pgSql databases.
• Used Oracle 11g OEM, Toad, Sql Developer, pgAdmin tool.
• Extensively used database tuning tools, sar, top, iostat, vmstat, lsof, tkprof commands and utilities.

Database Architect/DBA Consultant

Responsibilities:

• Database Architect and Administrator for DTI/DelDOT - Worked on the design, development and implementation of Oracle and SQL Server database projects supporting DelDOT applications.
• Providing 24/7 support of both production and development Oracle 11g/10g RAC and Non-RAC databases on various physical and virtual platforms.
• Installed software, patches, create, tune, upgrade and migrate Oracle databases on Windows and Linux operations system. Installed and configured several instances and databases for SQL Servers.
• Installed, configured, managed Oracle 11gR2 RAC (ASM) clusters on Linux.
• Led the efforts of application developments, created logical designs and ER diagrams using ERWin r7/8, Designer 11.2.
• Extensive experience with all versions of Oracle and SQL Server technologies with emphasis on RAC, Data Guard, Oracle Spatial, Partitioning, Replication, Reporting and Integration services.
• Coordinated effectively with various groups to make migration and upgrade seamless. Migrated several databases from physical to virtual machines saving the cost of new infrastructure.
• Played effective roles in architecture, design of database systems, data warehouse solutions, backup/recovery strategies, integration of many systems in both DMZ and Non-DMZ environments.
• Used Oracle Enterprise Manager to monitor, diagnose (ADDM, AWR) and tune (tuning advisor) the databases. Database tuning involved memory, CPU utilization, SQL and SGA tuning, Shared pool, buffer and Disk I/O tuning using OEM as well as tools like explain plan, statspack, trace and tkprof. Troubleshoot critical database issues, managed database locks and blocking sessions.
• Played key roles administering and regulating many applications running under ERMS, TIS and TA&E group including GIS applications using ESRI ArcGIS and GeoMedia tools.
• Installed and managed Oracle agents on many database, apps and web servers. Deployed Oracle agents from OEM to Linux/Windows platforms. Configured and managed Oracle Internet Directory (LDAP) for DelDOT.
• Extensive work on PL/SQL packages, stored procedures, functions, triggers, views and materialized views to retrieve and manipulate complex data sets in databases.
• Extensive work with planning the database growth and continuous capacity planning. Prepared and implemented maintenance plans for various databases.
• Automated the scheduling and execution of almost all the jobs using OMS jobs, DBMS JOB, Oracle Scheduler, Windows Scheduler, cron jobs and Windows AT. Facilitated the alerts and emails from the job executions.
• Supported databases running applications such as PeopleSoft, Trapeze CAD/AVL, Maximo, M4/M5, Primavera.
• Extensively used TOAD, SQL Developer, OMS, SQL*Loader to load data in flat file into databases.

Senior DBA Consultant

Responsibilities:

• Worked as DBA to strive for excellence by continuously planning and working on backup/recovery processes using effective tools, disaster recovery, implementing interfaces with other heterogeneous systems, capacity planning with emphasis on high availability and scalability.
• Led the efforts to consolidate the Oracle databases from several windows machines onto a SUN cluster. Managed the project of migrating all applications from SUN cluster to Linux servers.
• Installed and configured Oracle 11g/10g Grid control/OMS to monitor database and application servers. Performed OEM administrative tasks such as deploying agents, creating administrators and roles, and setting up notification rules and schedules for OMS administrators.
• Installed, configured, managed Oracle 9i RAC (OCFS) and Oracle 10g RAC (ASM) clusters on Linux.
• Configured physical standby databases using data guard broker, managed failover and switchover.
• Implemented the best practices with SQL Server databases, created several maintenance plan, created scripts to rebuild indexes, manage fragmentation, update statistics, backup and deletion of transaction log backups.
• Data modeling experience, accomplished several application development projects, created logical and physical designs using Erwin and Oracle Designer 2000. Accomplished reverse engineering of several applications, created ER diagrams and application design documents. Worked as repository and workspace administration.
• Worked with GIS applications using Oracle Spatial option, ESRI ArcGIS, ArcCatalog, ArcSDE and GeoMedia tools. Worked on Spatial data warehouses on Oracle and SQL Server database, architect the integration solutions.
• Worked on different retention and purging methodology for SQL Server databases, shrinking databases and log files, regular backup and truncation of transaction logs.
• Experience with Oracle Advance Security, Transparent Data Encryptions, Encryption and compression of tablespaces and backups, Oracle Golden Gate, PeopleSoft admin.
• Designed data model and databases, created ETL scripts, and performed DBA functions in Java, J2EE, PL/SQL, Oracle, SQL Server, Access and Windows/Solaris/ Linux environments.
• Written interfaces on Windows and Unix to facilitate the dataload jobs and data transfers and sharing activities among Unix, VAX and Windows databases.
• Worked on Data Mart and Data Warehouse projects using OWB, Oracle Discoverer and Cognos.
• Worked on numerous interfaces, data extract, datalaod scripts using shell and powershell scripts to get the data from several sources, VAX VMS, oracle and sqlserver databases.
• Contributed effectively in Share Point and Microsoft project initiative at OIT.