SUMMARY:

• Over 20 years in IT industry with over 13 years of expert level Sybase/Oracle DBA and development experiences
• Expert level experience in Oracle Administration tasks such as Installation, Configuration, Backup and Recovery, Application Tuning (SQL Tuning), Parameter Tuning, Disaster Recovery, Database Maintenance, System Implementation & Trouble shooting etc
• Expert level experience in Sybase Administration tasks such as Installation, Configuration, Data modeling, Data Warehousing, Database Fault Tolerance Designing, Database capacity Planning, Database Tuning, Database Maintenance, systems implementation and trouble - shooting
• Expert level Transact-SQL Skills with writing stored procedures, triggers, DML & DDL operations, batch & control-of-flow languages and working with tables, views, defaults, rules and T-SQL functions (string, date, aggregate, arithmetic etc)
• Expert level Experience with UNIX/Windows shell scripting in both Sybase and Oracle environments

TECHNICAL SKILLS:

Operating Systems: IBM AIX 4.x/5.x/6.x; Oracle Solaris 2.6/8/9/10/11; HP-UX; SCO Unix 4, Windows NT/2000/2003 Server/Workstation, Novell NetWare 4.x, RHEL/OEL

Hardware: IBM RS6000 P-series servers; Sun Solaris Servers; IBM PC compatibles, Compaq Servers, Dell Servers, Network Appliance NFS and FC SAN storage

Software/Methodologies: Oracle database (7.x, 8i, 9i, 10g, 11g, 12c); Oracle tools Enterprise Manager Grid/Cloud control, Data Guard, RMAN, expdp/impdp/sqlldr, PL/SQL, ASM, RAC, Clusterware; Sybase RDBMS (10.x,11.x,12.x); Microsoft SQL Server 7/2000 UNIX shell scripting; Windows batch Scripting; Embarcadero DBArtisan / Change Manager / ERStudio / RapidSQL, Seagate Report Builder; CA Autosys 3.5/4.5; Powerbuilder 6.x/7.x; CA Erwin

PROFESSIONAL EXPERIENCE:

Confidential

Environment: Oracle 10g,11g, Sun Solaris 9/10/11, IBM z/Linux, Oracle Linux/Redhat Linux, EMC storage, Embarcadero DBArtisan, SQL Developer, CA Erwin, Toad

Lead Oracle DBA

• In addition to the responsibilities below as a Senior DBA, I also lead a team of 7 other DBAs with responsibilities for setting and coordinating team goals
• Lead database technical sessions and communicating decisions to management in a timely manner
• Attending meetings and communicating same to the DBA team on project strategic directions as it relates to the team
• Act as liaison between the DBA team and the various application development teams both internal and external
• Responsible for providing daily and weekly status updates to management on a timely basis
• Responsible for task assignment and distribution for DBAs on the team
• Providing Mentoring to Junior Level DBAs on the team
• Currently leading the effort to upgrade over 100 oracle databases from version 11.2.0.4 to version 12.1.0.2 both for the RDBMS as well as Oracle restart
• Led the project-wide implementation of Unified Auditing and Privilege Analysis
• Creating and maintaining database storage structures such as tablespaces and objects such as tables, views, indexes etc
• Creating and Maintaining Oracle users, roles, database objects
• Database and target management using Enterprise Manager Cloud Control including incident management, target discovery, provisioning etc
• Developing and writing extensive PL/SQL Packages, procedures, functions and triggers
• Importing (impdp), exporting (expdp) and using SQL*Loader and other tools to move oracle data from one environment to another
• Extensive SQL tuning to achieve improved throughput and reduced response time using oracle utilities like AWR, ADDM, ASH and the advisors
• Working closely with application developers to understand requirements and defining best ways to accomplish them
• Performing regular database maintenance activities such as statistics update, index rebuild, block structure validation etc
• Working with Oracle support to open and resolve cases
• Applying oracle patches both interim and patch Set Update
• Installing, configuring, managing and administering Oracle Clusterware and Oracle Real Application Clusters (RAC) in a development environment
• Installing, configuring, upgrading and maintaining Oracle Databases from version 9i to 11g
• Installing, configuring, upgrading and maintaining Oracle Grid Infrastructure software
• Defining, testing and implementing backups and recovery procedures using RMAN and Netbackup policies
• Database cloning using export/import, ASM duplicate or ASM LUN copying
• Developing extensive Shell scripts to perform tasks such tasks as database space capacity, export dump, account management etc

Confidential, Baltimore, MD

Environment: Oracle 9i/10g/11g, Oracle Clusterware/RAC, Dataguard, Sybase ASE 12/12.5.x, IBM AIX 5.3.x, Sun Solaris 9/10, NetApp NFS & FC SAN storage, Microsoft SQL Server 2000/2005, Windows NT/2000 Servers, Embarcadero DBArtisan, Computer Associate Autosys Job scheduler, NetApp SnapManager for Oracle, RHEL/OEL

Senior Oracle Engineer

• Installing, configuring, managing and administering Oracle Database Servers and application tools in a 24*7 production and Development/QA environments
• Installing, configuring, managing and administering Oracle Clusterware and Oracle Real Application Clusters (RAC) in a production environment
• Setting up and maintaining disaster recovery using Physical Standby Database in a dataguard configuration including switchover, failover and gap resolution
• Capacity planning and system storage allocation for Oracle databases from the development phase to production roll-out phase in both NetApp NFS and FC SAN storage environments (traditional and ASM)
• Developing and maintaining automated shell/batch scripts to accomplish several tasks such as backup, export and import, statistics gathering, system and database monitoring etc
• Creating and maintaining database storage structures such as tablespaces and objects such as tables, views, indexes, procedures etc
• Enrolling users and maintaining adequate system security including controlling and monitoring user access to the database
• Cloning of Oracle databases and Oracle Homes
• Monitoring and optimizing database performance using various Enterprise Manager tools such as AWR, ADDM, SQL Access/Tuning, Segment Advisor, Memory Advisors, ASH etc
• Setting up, managing and administering standard auditing and Fine-Grained Audit (FGA) auditing
• Setting up, managing and administering Table column Transparent Data Encryption (TDE) encryption as well as RMAN database and tablespace backup encryption using AES 128/192 bits keys
• Tuning Oracle configuration parameters for optimum performance and standards and setting and optimizing database options
• Importing, exporting and using SQL*Loader and other tools to move oracle data from one environment to another
• Defining, testing and implementing backups and recovery procedures using RMAN and Network Appliance snapManager for Oracle
• Scheduling Ad-hoc and repeatable jobs using the grid control job scheduler
• Performing regular database maintenance activities such as statistics update, index rebuild, block structure validation etc
• System diagnostics using OS tools such as vmstat, iostat, top, nmon, netstat,oswatcher etc
• Downloading and installing Oracle upgrades and patches and contacting Oracle for technical support through Metalink and Oracle configuration Manager
• Working closely with Unix, Network and Storage engineers to get optimum database performance from the OS, network and storage layers at all times
• Working closely with application developers to understand requirements and defining best ways to accomplish them
• Involved to the little details in the complete Data Center Migration from Baltimore,MD to Stamford, CT
• Using CA Erwin to generate ERDs and reverse-engineering of databases into Logical/Physical models as well as forward-engineering models into physical databases
• Using CA Erwin to generate data dictionary information from the data models using report template builder
• Installing, configuring, managing and administering ASE and Backup Servers in a 24*7 environment
• 24*7 Performance and Tuning of over 100 ASE and other servers to achieve optimum throughput and response time.
• Defining and creating standards for ASE proxy table definition and maintenance as well as remote server configuration
• Defining and managing ASE standards such as resource limits, execution classes (LPM), login triggers, ASE monitoring tables, XP servers, Monitor servers etc
• Manipulating ASE character Sets/ Sort orders to achieve desired results.
• Trouble-shooting, bench-marking, errorlog analysis and simulating scenarios to achieve the best result at all times.
• Planning and executing dbcc checkstorage and other dbcc options to maintain and guarantee page allocation and page linkage consistency in databases and repairing any identified faults

Confidential, Chicago, IL

Environment: Oracle 9i/10g, Sybase Adaptive Server Enterprise (ASE) 11.9.2/12.x, Sybase Replication Server 12.0, Microsoft SQL Server 7.0/2000, Sun Solaris 2.6/8.0, Windows NT/2000 Servers, Windows XP Servers. Embarcadero DBArtisan, Change Manager and ERStudio/Repository

Oracle DBA

• Installing, configuring, managing and administering Oracle 9i databases in a 24*7 environment using EMC storage systems
• Defining backup as well as recovery strategies for Oracle databases
• 24*7 Performance and Tuning of over 12 oracle instances to achieve optimum throughput and response time.
• Tuning Oracle configuration parameters for optimum performance and standards and setting and optimizing database options
• Designing and Managing oracle authentication using both the OS authentication and password file authentication (ORAPWD) methods
• Assisting developers and data analysts with physical and logical database designs for optimum performance.
• Importing, exporting and using SQL*Loader and other tools to move oracle data from one location to another
• Trouble-shooting, bench-marking, alert log analysis and simulating scenarios to achieve the best result at all times.
• Performing Database Re-indexing, Statistics computations and other regular maintenance tasks and defining maintenance standards for smooth Oracle databases operations
• Defining standards for Archiving and purging old data from the system.
• Creating and Maintaining Oracle users, roles, database objects
• Developing Automated UNIX shell scripting to automate maintenance tasks such as re-indexing, statistics computations etc.
• System diagnostics using OS tools such as vmstat, iostat, top, nmon etc
• Working closely with Unix and Storage engineers to get optimum database performance from the OS and storage at all times
• Data Migration from Microsoft SQL Server and Oracle databases and Vice Versa
• Using Embarcadero ERstudio/Repository to generate Logical/Physical database models and reverse-engineering of databases into Logical/Physical models
• Analyzing feedback from end-users and taking appropriate corrective and tuning actions.
• Installing, configuring, managing and administering ASE and Backup Servers in a 24*7 environment
• 24*7 Performance and Tuning of over 15 ASE and other servers to achieve optimum throughput and response time.
• Tuning ASE configuration parameters for optimum performance and standards and setting and optimizing database options
• Assisting developers and data analysts with physical and logical database designs for optimum performance.
• Trouble-shooting, bench-marking, errorlog analysis and simulating scenarios to achieve the best result at all times.
• Performing Database Re-indexing, Updating statistics, Re-org Rebuild, dbcc commands and other regular maintenance tasks and defining maintenance standards for smooth ASE operations
• Defining standards for Archiving and purging old data from the system.
• High level T-SQL query tuning to achieve cheaper query cost and optimum response time.
• Creating and Maintaining ASE logins, users, roles, database objects on ASE
• Developing Automated UNIX shell scripting to automate maintenance tasks such as re-indexing, dbcc, reorg rebuild etc.
• Data Migration from Adaptive Server Enterprise (ASE) and Microsoft SQL Server and Vice Versa
• Managing and keeping up-to-date different ASE environments using Embarcadero Change Manager
• Using Embarcadero ERstudio/Repository to generate Logical/Physical database models and reverse-engineering of databases into Logical/Physical models
• Co-coordinating Replication activities to achieve smooth operations at all times and reduced latency.
• Analyzing feedback from end-users and taking appropriate corrective and tuning actions.

Confidential

Lead Sybase DBA /Developer

Environment: Sybase SQL Server 10.x/11.x, Sybase ASE 11.9.2/12.0, Sybase Replication Server 11.5, Powerbuilder 6.5/7.0 Enterprise, IBM AIX 4.x on J50/H50/S80/S85 servers, Windows NT Server 4.0/2000, Novell Netware 4.0, TCPIP Networking.

• Installing, configuring, managing and administering ASE and Backup Servers in a 24*7 environment
• Implementing efficient logical and physical database designs for optimum performance
• Creating and managing Adaptive Server logins, users and databases
• Installation, Configuration and administration of Sybase Replication server, setup of Replication system in production and development environment
• Defining Replication definitions, subscriptions, connections, routes etc on the primary and replicate replication servers
• Managing and monitoring the use of disk space, memory, engines, caches, database/dump devices, locks, connections etc
• Performance and tuning of ASE and other servers to achieve optimum throughput and response time
• Defining and using ASE utilities such as bcp, defncopy etc
• Housekeeping and maintenance tasks such as dbcc, re-indexing, update statistics etc
• Developing effective and efficient backup, restoring and recovery strategies
• Configuring open client for both windows and IBM RS/6000 platforms
• Maintaining a seamless handshake at all times between ASE and phoenix banking application and also between ASE and IBM AIX 4.x
• Integrating third-party applications developed on ASE back-end to phoenix.
• Managing and maintaining IBM AIX 4.x O/S
• Supervising, Training and Mentoring other junior DBAs
• Providing team support, making recommendations, troubleshooting help to multi- application groups.
• Developing and writing SQL scripts, stored procedures, triggers, cursors etc meant for querying and manipulating information stored in ASE using T-SQL
• Creating and manipulating database objects such as tables, views, defaults, rules, stored procedures etc
• Extensive DML operations (Insert, delete, update etc), DDL operations (create, alter, drop etc), order by and group by operations, compute clauses, having clauses, etc using T-SQL
• Working with joins (inner & outer) and sub-queries to pull out data in ASE
• Extensive use of T-SQL functions (date, arithmetic, aggregate, string etc) to manipulate ASE information
• Developing SQL batches and using Control-of-Flow language
• Interpreting physical database models and understanding relational database concepts such as indexes, primary and foreign keys, common keys and constraints.
• Extensive user support and administration of phoenix banking software
• Extensive experience writing application software, data analysis, data access, data structures, data manipulation, programming, testing and implementation, technical and user documentation on various hardware platform ranging from large server machines to laptops notably using powerbuilder and Sybase back-end
• Assisting and/or leading in the design of program specifications and the implementation of software solutions.
• Developing Client/Server applications using an ASE back-end and powerbuilder 6.x and 7.0 front-end development tools.
• Setting up and administering NT-based LANs
• Training new employee on ASE and powerbuilder programming tools and developing application programs technical manuals

Confidential

Environment: Sybase RDBMS (Sybase SQL Server 11.x, Oracle 6.x/7, Developer 2000, Designer 2000, PL/SQL, PowerBuilder 5.0, Windows NT, Novell Netware 4.0

Sybase/Oracle Developer

Responsibilities:

• Systems analysis and design
• Developing and writing SQL scripts, stored procedures, triggers, cursors etc meant for querying and manipulating information stored in Sybase SQL Server using T-SQL
• Creating and manipulating database objects such as tables, views, defaults, rules, stored procedures etc
• Extensive DML operations (Insert, delete, update etc), DDL operations (create, alter, drop etc), order by and group by operations, compute clauses, having clauses, etc using T-SQL
• Extensive use of T-SQL functions (date, arithmetic, aggregate, string etc) to manipulate ASE information
• Generating SQL Scripts using Oracle SQLplus
• Writing PL/SQL packages, procedures, functions and triggers
• Developing applications using Developer 2000 tools
• Developing technical manuals on Microsoft office suites and training of clients on its usage

Confidential

Environment: Informix RDBMS, SCO UNIX 4, Novell Netware 3.x

Trainee Programmer

• Extensive learning and application of Structured Query Language (SQL)
• Training of clients on the use of Windows O/S and Microsoft Office Suites
• Introduction to SCO UNIX system V Release 3 in a Host/Terminal environment
• Participated in the development of a computerized Account Receivable system using INFORMIX in a SCO UNIX Host/Terminal environment.