PROFESSIONAL SUMMARY

An accomplished Database Administration with twelve years success in designing, implementing, and managing database solutions that improve business functionality. Possess a diversified technical background with Enterprise Systems Solutions. Proven ability t implement resources that decrease cost increase performance and consistently exceed targeted goals.

TECHNICAL EXPERTISE

• Lotus Notes Crystal Reports
• Oracle Web logic Oracle 11g Exadata
• Greenplum Automated deployment packaging

PROFESSIONAL EXPERIENCE

Confidential

Sr. Database Architect lead

Projects Accomplished

Eectronic Lab Note, Disaster Recovery, Cambridge Consolidation, JReview, Openlab CDS.

• Conducted periodic security evaluation on application and data system level and developed action plans.
• Provide effective communication of project status and other pertinent information t upper management.
• Installation, upgrades, migrations, performance tuning, backup and recovery, schema management, SQL tuning, proactive monitoring and troubleshooting Oracle databases in a 7x24 environment.
• Implemented and support of 10g and 11g migrations and upgrades from Oracle 9i and 10g databases, including RAC Real Application Clusters databases on HP-UX and Linux.
• Participate in the selection process for new IT solutions.
• Evaluate options and design architecture solution for backend database environments and web-based systems in order t support business, technical, and service-level objectives.
• Support the development of strategy, frameworks, best practices and patterns working with architects from other IT functions.
• Implemented, documented and support builds of new clusters t use Oracle 10g/11g RAC on HP-UX and Linux. Including installing clusterware, ASM and shared disks and creating new databases.
• Provide support for Oracle Enterprise Manager Grid Control and Agents.
• Designed backup strategies using both Oracle RMAN, Microsoft SQL inbuilt backup and COMMVAULT backup capabilities.
• Developed and implemented a comprehensive Disaster Recovery Plan for the Oracle and Microsoft SQL databases
• Define and communicate the technical roadmap and lifecycle for the components and systems supported by the database administration team.
• Conduct technical reviews of all new projects and enhancements t existing installed base t assess impact t existing and future architecture plans.
• Maintain up-to-date knowledge of technology standards, industry trends,emerging technologies, and software development best practices.
• Perform proof-of-concept evaluations t assess capabilities and appropriate fit within architecture.

Confidential

Oracle DBA/SQL admin Lead

DITE project

Greenplum

• Responsible for the performance, integrity, backup and security of Greenplum
• Databases.
• Installation and configuration of Greenplum full-rack DCA and database.
• Management of query processes via GP command Center.
• Proficient in use of data domain for backup and recovery of GP databases.
• Heavy experience with Linux and shell scripting for maintaining and administering GP
• DCA.
• Periodic use of vacuum and analyze t optimize psql query and database efficiency.

11g Database

• Responded t database events including resource management, performance monitoring of cluster administration, managing high-availability, scaling VLDB, database recovery, and distributed partitioned database design.
• Reported of AWR, Alert logs, Oswatch archives and Daily stream lag study and analysis of the electronic filing databases.
• Established Standard Operating Procedures for the Database and application support teams.
• Performed grid control monitoring and maintenance of all 11g databases.
• Oracle Golden Gate implementation and maintenance.

CADE2 project Oracle 11g Exadata

• Implementation of Oracle Exadata database machine X2-2 half rack.
• Installed Oracle Exadata storage server software and higher.
• Install oracle aut service request ASR package for Exadata.
• Configure Fault Telemetry Destination for oracle Exadata.
• Monitoring of Exadata database, storage server, infiniband network, KVM , PDU, ILOM, CISC SWITCH.
• Validate application performance using SQL performance Analyzer and Database Replay.
• Oracle Exadata performance Diagnostic and tuning.
• Software tools involved
• Automated Deployment Packaging.
• Rational Clear case.
• Rational Clear Quest.
• Humming bird exceed.
• Kisam help ticket system.
• ITE DITE and production Tivoli infrastructure .
• Installation Request Tracking Tool IRTT .
• Tivoli inventory, software distribution and Desktop

Confidential

Oracle DBA/SQL Server Admin

• Manage development, test and production Oracle Databases on Sun Solaris environment.
• Installing client/server Oracle 11g software application.
• Monitoring database space utilization and performance of the production databases.
• Monitoring, configuring, updating, and optimizing production databases.
• Installing MS SQL Server and maintained multiple Access database.

Confidential

Oracle DBA

Modernized Electronic Filing MEF

11g Database

• Responded t database events including resource management, performance monitoring of cluster administration, managing high-availability, scaling VLDB, database recovery, and distributed partitioned database design.
• Reported of AWR, Alert logs, Oswatch archives and Daily stream lag study and analysis of the electronic filing databases.
• Established Standard Operating Procedures for the Database and application support teams.

Performed grid control monitoring and maintenance of all 11g databases.

GREENPLUM Project EMC

• Executed Oracle database conversion t Green plum EMC database.
• Created and managed scripts for internal and external table creation in Green plum database.

Confidential

Oracle DBA/SQL Server Admin

• Strong knowledge of Oracle data warehouse designing.
• Excellent Oracle data modeling ability.
• Developed the Oracle data warehousing and reporting scheme currently in use within the HR system.
• Provide operational support in scheduling the ETL jobs for Oracle data extraction from source systems t the Operational data warehouse.
• Installed and configured Oracle Web Logic Server 11g.
• Created and configured domain on Oracle Web Logic Server.
• Created and configured Oracle Managed Server.
• Created Oracle Web Logic Server Cluster on Solaris 10.
• Used WLST t deploy applications.
• Configure JDBC Data Source on Web Logic Server 11g.
• Implemented Oracle grid control and Real Application Cluster.
• Built Sun Solaris servers using Jump starter.
• Built and administered SQL server 2005-08 on windows.
• Monitor Nagios, Red alert, and Raritan systems.
• Responded t hardware problems and system outages.
• Designed solutions for new business initiatives Deltek, Cognos .
• Provide software and hardware support for a very diverse datacenter.
• Implemented new projects within the data center.
• Built Linux servers using Jump starter.

Confidential

Oracle DBA

• Migrated Our Oracle DB server from Solaris 8 t 10, worked with the Unix Admin team t accomplish this task.
• Modified Oracle grid Control installation t configure options and add multiple databases ont the grid for global management.
• Installed Oracle Grid control agents on both UNIX and window servers for Database global management purpose.
• Troubleshot Oracle database connection issues, performance issue and all day t day ticket issues reported by the customers.
• Monitored a large number of Oracle production databases in a fast paste environment, for databases sizing over 200GB.
• Maintained daily Oracle database backup, troubleshoot failed backups and manually executed failed backups as required.

Confidential

Oracle DBA

• Provided technical services in motoring and maintaining the production and test databases managed on INTEL, UNIX, and LINUX servers.
• Installation of Real Application Cluster.
• Managed Oracle Enterprise Manager and 10g grid control.
• Managed backup disk space and allocation and database backup execution.
• Installed, integrated and tested new versions of database software and server scripts required for automation backup and security checks and modification upgrading database software, installing software patches, patchsets and security fixes .
• Administered enterprise-wide passwords, recovering from media software and database failures documentation of procedures and automation of regularly scheduled tasks.
• Monitored VCS and ASM environment with scripts.

Confidential

Database Engineer

• Managed development, test and production Oracle Databases on Sun Solaris environment.
• Performed Hot and Cold backups using both RMAN and Oracle exp utility.
• Installed and patched Oracle software on both UNIX and Windows environment.
• Loaded Oracle data using SQL Loader and non Oracle data using ODBC.
• Upgraded Oracle 9i Database from 9.2.0.1 t 9.2.0.7 on both Unix Windows
• Provided remote technical support for clients using SSH and terminal services.
• Implemented Oracle password authentication, Data integrity and Role creation t control database access and modification.
• Implemented a Disaster Recovery Facility DRF plan according t policies.

Confidential

Data Analyst/SQL Server Admin

• Installed client/server Oracle 9i, 10g software application.
• Monitored database space utilization and performance of the production databases.
• Oracle's Enterprise Manager OEM , Statistic Package Reports, Explain Plans, SQL Trace and TKPROF.
• Monitored, configuring, updating, and optimizing production databases.
• Created SQL scripts t create tables, keys, views, indexes and synonyms required t meet developer needs.
• Produced physical databases with multiple table spaces from logical data model.
• Performed cold and hot backup of databases using Oracle's export utility.
• Implemented database securities using roles and profiles.
• Prepared scripts t tune developer SQL codes t maximize result return time.
• Installed MS SQL Server and maintained multiple Access database.
• Installed, configured Oracle 9i and created databases sizes up t 80GB on Solaris 2.8.
• Troubleshoot database connectivity problems and other related problems
• Implemented database securities using roles and profiles.
• Performed database migration from 8.1.6 t 8.1.7
• Created backup scripts for logical backups and automated the scripts.