PROFILE:

• Over fourteen years of experience in software engineering and information systems management. The last nine years in the design, implementation, data modelling, maintenance, and control of the organization's physical, relational, and object - oriented databases across multiple platforms and computing environments. Experience includes extensive hands on installation and configuration of Unix, Windows NT/2000, Oracle, Empress, MySQL and SQL Sever software and their upgrades, planning and design of databases in OLTP and DSS environments
• Eight years of experience in database performance tuning, developing and implementing backup, disaster recovery, maintaining HA systems such as RAC and Veritas Cluster, Database encryption, Data Guard implementation, migration of databases, creation and maintenance of database user accounts, database auditing and security, Oracle network administration; database maintenance, database replication and parallel processing; database performance monitoring, analysis, and tuning using custom scripts, Oracle OEM, Oracle Management Server.
• Seven years of experience in logical and physical data modeling, normalization, and database design and implementation for OLTP databases for e-commerce, finance and banking industries
• Three years of experience in dimensional modeling (star schemas), architecture, design, and implementation of data warehouses, and operational data stores for banking industries five years of experience in developing database PL/SQL programs (triggers, procedures, and functions), SQL scripts, and Unix shell scripts to extract, transform, and load data from different data sources to Oracle OLTP and DSS databases

TECHNICAL SKILLS:

Languages: C, SQL, PL/SQL, Java, UNIX shell scripting (K shell), XML, and PERL Programming

RDBMS: Oracle 7.X/8.x/8i/9i/10g/11gr2, MS SQL Server 6.5/7.0/2K and DB2 UDB 7.x, MYSQL, Postgress, Empress 8.62

Tools: Veritas Volume Manager (VxVM), File System (VxFS), and Clusters, Disk Suite, Solaris Admin tool, Oracle RAC, RAID Manager, Export/Import, SQL*Loader, Oracle Dataguard, Informatica, Cognos, Microsoft DTS, SQL*Plus, Net9, OEM, OMS,TCP/IP, TOAD, ODBC, JDBC, Erwin, RMAN, DB Artisan, and Veritas Netbackup Server

Operating Systems: Sun Solaris 7/8/9, Compaq, Linux Red hat 6.1/6.2, HP-UX, MS DOS, Windows 95, Windows 98, Windows NT, and Windows 2000

Systems: IBM PC's and Compatibles, SUN Disk Arrays, and SUN enterprise servers

EXPERIENCE:

Sr. Database Administrator

Confidential, San Francisco, CA

Responsibilities:

• Managed all aspects of installation/deployments, configuration, integration, patches, upgrades (to 12c), troubleshooting, optimization, and maintenance of database/Application in DEV, QA, UAT and production environments.
• Successfully engineered, implemented, documented and support builds of new clusters to use Oracle 10g/11g RAC on Linux, including clusterware installation, ASM and creating new databases.
• Installed, configured, upgraded, migrated and patched oracle databases in heterogeneous environment.
• Extensive experience with RAC installations, RMAN backup and recovery, OEM, DataGuard, database performance tuning and troubleshooting, and replication technologies Golden Gate and Oracle Streams, Disaster recovery planning,
• Identified, resolved, and provided recommendations to different performance issues ranging from database performance problems to I/O hardware issues, developed and reinforcing standards, procedures, and policies for change management, object naming, data archival, data purging, database security plan and auditing, reinforced security standards, deep dive of audit and SOX controls and provide on-call support (on rotation basis) and escalations in 24x7 production environment

Sr. Database Administrator

Confidential, Pleasanton, CA

Responsibilities:

• Managed team of DBA’s onsite and offsite spread across the globe.
• Managed Data center migration project which involved databases were being migrated from HP/EDS in-house facility to central location.
• Planning and migrating very large oracle databases from non-RAC to RAC with ASM and cross platform migration using RMAN, Golden gate and transportable tablespace technology.
• Architecture, configuration, tuning, troubleshooting, and maintenance of high availability(HA) systems using Oracle Data Guard in UNIX environments and Solaris VERITAS cluster environment and RAC on Linux environment, RMAN, OEM, database encryption technologies using TDE and sqlnet encryption,
• Managed and reinforced security standards, deep dive of audit and SOX controls, database monitoring, capacity panning, performance diagnostics, optimization, backup and disaster recovery planning using RMAN, business resumption procedures for mission critical systems, database and SQL tuning, replication, and partitioning,

Sr. Database Administrator

Confidential, San Francisco, CA

Responsibilities:

• Installations, configurations and maintaining 3600 branches on Empress 8.62 databases.
• Planning and migrating corporate very large Oracle databases to Oracle RAC environment on HP-UX.
• Architecture, configuration, tuning, troubleshooting, and maintenance of high availability(HA) systems using Oracle Data Guard in UNIX environments and Multi Master Replication in Solaris and VERITAS cluster environment.
• Improved database and systems administration efficiency by 100% through upgrades and consolidation of multiple databases and systems.
• Achieved a 90% reduction in application and database system outages by implementing automated monitoring/alerting and through streamlining procedures
• Database monitoring, performance diagnostics, optimization, backup and disaster recovery planning using RMAN, business resumption procedures for mission critical systems, database and SQL tuning, replication, and partitioning
• Developing shell scripts, SQL, and PL/SQL programs for OLTP, and generating adhoc reports
• Developing and maintaining applications in PRO*C
• Provide on-call support (on rotation basis) in 24x7 production environment

Sr. Database Administrator

Confidential, Oakland, CA

Responsibilities:

• Provide architecture and performance tuning recommendations.
• Installations, configurations for oracle 9i and 10g databases in heavy transaction volume environments
• Tuning, troubleshooting, and maintenance of high availability(HA) systems using Oracle RAC on Linux environments
• Developing and reinforcing standards, procedures, and policies for change management, object naming, data archival, data purging, database security plan and auditing
• Database monitoring, performance diagnostics, optimization, backup and disaster recovery planning using RMAN, business resumption procedures for mission critical systems, database and SQL tuning and partitioning, refreshing data from production to development.
• Developed HTML DB user interface for space calculation, adhoc reporting and partition compression.
• Developed shell scripts, SQL, and PL/SQL programs for OLTP and data warehouse databases.
• Provide on-call support (on rotation basis) in 24x7 production environment
• Monitoring load on the server, memory usage, disk space, capacity planning, space management etc.
• Refreshing databases for adhoc users on daily basis using snapshot technology of 3PAR storage
• Enforcing backup strategy using snapshot of 3PAR storage.

Database Administrator

Confidential, Santa Clara, CA

Responsibilities:

• Installations, configurations for oracle 8i databases in heavy transaction volume environments
• Responsible for E-R data and dimensional (star schemas) modeling (logical/physical), database design, capacity planning, database creation, and physical layout of OLTP and data warehouse databases in development, QA, and production as well as in distributed database environments in compliance with OFA
• OLTP databases performance monitoring and tuning, backup and restore, database migration, database cloning, materialized views, database security, data purging, data archiving, database upgrades and patches, space management, problem diagnosis and troubleshooting activities
• Planning and implementation of high available database and other systems through replication and standby configurations. Also planned and implemented disaster recovery systems for databases, data warehouse, web/application servers
• Systems and database monitoring, maintenance, and troubleshooting. Writing PL/SQL programs, SQL, shell and PERL scripts

Oracle DBA

Confidential, Denver, CO

Responsibilities:

• Responsible for managing Oracle databases running in development and production on Sun Solaris, Linux, and Windows NT /2000 servers
• Responsible for database capacity planning, monitor and optimize database query performance and resource usage, create and manage database schemas, database performance monitoring, analysis and tuning, develop and implement data purging and archival procedures, database backup, upgrade and patch installation, moving databases across servers, Oracle partitioning, database cloning, create stand-by databases, plan and implement database replication, and development and maintenance of custom scripts for automation of database administration and maintenance procedures.
• Responsible for providing 24x7 support for OLTP in complex and multi-master data replication environments. Responsible for configuration and maintenance of high availability database systems. Also responsible for establishing, testing and implementing database security, backups, restore, and disaster recovery.

Database Administrator

Confidential, Juno Beach, FL

Responsibilities:

• Database design, E-R diagram, Logical, Physical layout design, Capacity Planning.
• Installation, upgradation and patches of Oracle 7.3.4/8.0.4 Enterprise Edition database software on UNIX servers: Sun Solaris, HP-UX and MS Windows NT 4.0 server.
• Creation of multiple Instances databases tablespaces/datafiles, RBS, users and roles, schemas, tables, indexes.
• Used SQL *Loader to convert data from SQL Server to Oracle database.
• Extensively worked on Production Support of database.
• Backup and recovery procedures of Oracle database: Cold/offline backup and Hot/online backup through Archive log mode.
• Managing tablespaces/datafiles, archived redo log files, control files.
• Monitoring load on the server, memory usage, disk space etc.
• Tuning of database performance. Finding Performance bottlenecks using UTLBSTAT, UTLESTAT, ESTIMATE, ANALYSE,EXPLAIN PLAN,SQL TRACE,TKPROFF
• Support to developers, end-users.

Environment: Oracle 8.0.4, SQL*Loader, PL/SQL, OEM, SQL Trace, TKPROFF, Sun Solaris 2.6, AIX 3.2, Window NT

Oracle Developer /Database Administrator

Confidential

Responsibilities:

• Created databases, tablespaces, schemas, and roles.
• Created triggers, packages, functions and procedures using PL/SQL
• Responsible for preparing the Software Requirement Specification document.
• Used Developer 2000 for developing many of the forms.
• Generating reports, according to customer requirements.
• Developed stored procedures and triggers at the backend for database consistency.
• Using stored procedures for data integrity. (Ex. Used stored procedures for auto code generation)
• Using ORACLE Reports to generate Reports
• Loaded data from flat files using SQL*Loader.
• Responsibilities include unit testing, bug fixing and documentation.
• Responsibilities include unit testing, bug fixing and documentation.