Summary

• Seeking a senior 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 who 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 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, development and integration guidelines for DBAs and Developers including conventions. Prepared and implemented maintenance plans for various databases.

Core Competencies

Technical Skills

• Oracle 12c/11g/10g/9i/8i/7 SQL Server 2012/2008/2005 SQL Server Management Studio
• Oracle 11g Grid Oracle 10g/9i/8i OEM/OMS Peoplesoft ERP Financials HR
• Oracle RAC/Data Guard C/C /PLSQL/SQL Plus/SQL Loader MS Access MS IIS
• Quest TOAD/SQL Developer Oracle datapump /export/import Unix admin/shell scripts ERWin
• 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
• SQL Server Reporting/Integration Services T-SQL Microsoft Office MS Visio/Outlook
• Oracle Designer Web Logic Apache Maximo/M4/M5/Trapeze
• EMC Storage VERITAS NetBackup Backup Exec TIVOLI TSM Backup server

Professional Experience

Confidential

Senior Database Administrator

Responsibilities:

• Database Administration for Oracle 11g Data Warehouse, Oracle RAC 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.
• 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.
• 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.

Confidential

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.
• 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.
• Extensive work on PL/SQL packages, stored procedures, functions, triggers, views and materialized views to retrieve and manipulate complex data sets in databases.
• Expertise in maintaining Database Security, create role, profile and users, managed privileges using role based security.
• 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.

Confidential

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.
• Performed extensive performance tuning for critical databases, implemented oracle partitioning solutions on the tables and indexes. Worked very closely with in-house developers recommending, implementing the best practices with SQL tuning.
• 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.
• Written T-SQL, PowerShell and shell scripts to manage DBA activities for databases and send alert reports to keep DBAs proactive.
• Extensively worked with PL/SQL programming, created Packages, Stored Procedures, Functions, Database and event based triggers. Created Views and Materialized Views, automated Materialized Views on demand refresh using scheduled database jobs. Also utilized DBMS REFRESH and DBMS MVIEW packages.
• Data modeling experience, created logical and physical designs using Erwin and Designer 2000. Accomplished reverse engineering of several applications, created ER diagrams and application design documents. Worked as repository and workspace administration.
• Worked on installation, configuration of Peoplesoft/ERP applications and its components such as Peopletools, Tuxedo, Weblogic, Crystal reports, MF Cobol etc. for troubleshooting and DR tests.
• Worked with in-house Peoplesoft consultants and Ciber team on several Peoplesoft HR/Fin upgrade projects. Involved in application server, web server configuration/tuning, troubleshoot problems and tuning the Oracle queries.
• 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 solutions to integrate and replicate data shared among various applications. Did extensive troubleshooting and performance tuning.
• 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.
• Filled the role of Unix Administrator. Played very active role in implementation of DelDOT's Data Warehouse projects like EDEE/ODS, GIS/INFORM and HR. Helped evaluating the selection of ETL tools like OWB and COGNOS and implementing COGNOS as reporting tool.
• 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.
• Setup, configured Oracle Internet Directory LDAP , Oracle Names Servers as a replacement to painstaking Local Naming system.
• 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. Used PHP files and PHP encryption. Used Triggers and PL/SQL procedures to automate data manipulation and data massaging.
• Contributed effectively in Share Point and Microsoft project initiative at OIT.

Confidential

Senior Oracle DBA Consultant

Responsibilities:

• Designed and implemented business rules in Oracle, AIX, HP-UX and Solaris environments. Installed, managed, monitored and performance tuned Oracle databases.
• Made physical and structural changes in Databases to make them conform to CSC Oracle database standards.
• Automated Cold Backups/Exports/Hot Archiving using Unix shell and Perl scripts.
• Developed command center database to measure the free space in tablespaces, Rollback segments, fragmentation of data segments and free spaces before OEM/OMS was available .
• Meticulously planned the measurements and trend analysis on these ever growing databases.
• Generated Alert Reports. Made changes to database schema per requirements of System Designers.
• Monitored and tuned the database extensively using tkprof, Query Analyzer, explain plan.

Confidential

Sr. System Analyst/DBA

Responsibilities:

• Managed the entire life cycle of the application software development and coordinated development team efforts through planning, organizing and running the entire process until successful implementation. Worked on Public Deposit Scheme PDS and Leave Accounting Systems.
• Designed and implemented business rules in Oracle, Unix environments. Installed the oracle software, created databases, managed security, schema objects, segments, extents, monitored and performance tuned Oracle databases. Used utlbstat, utlestat, dbv and tkprof for analysis.
• Carried out Logical Physical Design and Data Modeling for software development implementation of Leave Accounting System, a module of Integrated Payroll System, a 100GB Database.
• Automated Startup/Shutdown of Oracle on System by writing unix shell scripts. Automated Cold Backups/Exports/Hot Archiving using unix shell scripts. Created tablespaces, tables, synonyms, dblinks, sequences, indexes and clusters.
• Extensive performance tuning jobs done for PDS system on Oracle 7.3. It involves developing tuning scripts to monitor 50GB database on regular basis. Meticulously planned the measurements and trend analysis on this ever growing database and space and segment management.
• Worked as system analyst. Managed the entire life cycle of the application software development and contributed from design through successful implementation. Worked on Inventory Control, Financial Accounting, Costing and Asset Inventory Systems. Computerization efforts and XYZ/ABC analysis helped the Steel plant to save a lot by maintaining low inventory and adopting effective cost and depreciation methods.