PROFESSIONAL SUMMARY

11 Years of total IT experience in Software Systems Design Development, responsible for developing customized business applications, database design, database administration, Leading Projects and building large public domain databases. 9 years as Oracle Database Administrator Proficient in Oracle Database Administration Activities . Installation, configuration, creation, upgrades Oracle environments 8i/9i/10g using OS via. AIX, Sun Solaris, SCO-Unix and Windows XP/NT servers. Experience with database backup, restore, and disaster recovery procedures using RMAN and shell scripts Transportable Tablespace, Recovery disaster recovery and Tivoli Storage Manager TSM. Oracle Data guard and Standby databases experience Experience as On-Call 24x7 production DBA support, application/development DBA, system administrator handle business service requests using Helpdesk Service Management/Call centre. Managing team and individual targets, addressing monitoring performance, coach, counsel and develop people competencies with in the team etc. Experience in all facets of the systems development lifecycle, from requirement development, architecture design, growth analysis, testing, and post implementation revisions. Strong in data system analysis, DBA support of phases of Software Life Cycle design development, implementation in large-scale multi-user systems environments. Strong in knowledge of oracle data-dictionary, configuration of Oracle Enterprise Manager OEM tools for monitoring, performance enhancement and debugging Involved in replication setup, configuration and maintenance of replication process. Building ad-hoc queries/ complex SQL queries Report development, Troubleshoot/monitor script, creation of log files, packages script, develop scripts for SQL Loader, Export, Import, DataPump, PL/SQL, Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage area Networks SAN /Network Attached Storage NAS . Monitoring and optimizing the Performance of the database, turning Management, Change Management, capacity planning, create new technologies and SQL tuning. Working experience with Very-Large databases VLDB over 1 terabytes, data migration, against Oracle other databases such as DB2, MS Access, SQL Server. Practical solutions to problem solving with creative ideas, identify patterns, linkages and underlying situations, consider customer needs in evaluation of solution. True team player maintain client/customer relationships by providing timely, superior quality products and services understanding of client/customer needs opportunities and satisfaction criteria.

SOFTWARE: Oracle from 6 to 10g, 11i RDBMS with its utilities, tools, options and features SQL, PL/SQL, Net,Export/Import, Data Pump, Advanced Replication, Streams, DataGuard, RMAN, Standby, RAC, Discover, Forms, Reports Builder, Autosys, Data Warehousing,OPS, Streams, Shareplex, Oracle Application Server 10i,OEM , CRM Siebel 6/7.5, OracleFinancials, Erwin, Embarcadero Artisan, VERITAS.

HARDWARE: AIX, Sun ES10000/6000/5000/4000,IBM SP, RS/6000 S80/S70/H70, HP9000, Linux, DEC, Intel, Pyramid, EMC SAN, Hitachi, MS Windows.

EXPERIENCE:

Confidential

• Daily database monitoring for optimization and fine performance tuning. Troubleshooting. Providing solutions on different levels using varicose optimization techniques SQL, storage, configuration, snapshots and Materialized Views, etc. . Created tuning and monitoring procedures. Setup OEM for monitoring.
• Headed companywide performance tuning project. Created, tested and implemented tragedies for performance improvements using Advanced Replication and Oracle Streams.
• Implemented new databases as well as redesigned/remodeled existing to accommodate new applications developed in house and to have them comply with new performance requirements.
• Setup of complex autosys jobs for daily refreshes of staging and development databases
• Work closely with Software Engineering and Web Development teams assisting and guiding on database related issues SQL tuning, procedures and packages utilization, altering schemas
• Set up and maintain database security policies
• Monitoring technology marketplace and advising on company's direction in Oracle field as necessary

Confidential

Senior DBA

For major data processing company was responsible for several 10G databases 1Tb and higher in size on Sun 10. As part of DBA team was working on simulation of server/database environments for major companies such as IBM, AT T and Deutsche Bank. Main duties were performance, availability and scalability tuning and optimization during testing of Data Processing applications. As team leader was responsible for growth analysis, planning and implementing disaster recovery systems which included Data Guard. Acted as a liaison between DBAs, business analysts and developers. Monitored technology, marketplace and advising on company's direction in Oracle field as necessary. Was responsible for major upgrades and installs. As part of team was responsible for developing tuning and optimization strategies.

Confidential

Senior DBA

For leading provider of consumer communication services, as part of DBA team, was responsible for management of 1.5tb production database and several development and testing environments. Specific responsibilities included monitor the state, tune and troubleshoot Oracle 10g database on AIX 4.3, construct, maintain and execute both physical and logical backup/recovery procedures and strategies including Hot Standby, generate application seed database and data, deploying staging environments, growth analysis, set up and maintain database security policies, upgrades and patching. Work closely with Software Engineering and Web Development teams assisting and guiding on database related issues SQL tuning, procedures and packages utilization, altering schemas

Confidential

Senior DBA

For a leading globally integrated CRM solutions provider as part of DBA team responsible for 24/7 production administration and support of 120 Oracle both OLTP and Data Warehouse databases ranging from 25gb to 1tb in volume, running on combined AIX/NT environment. Responsibilities included daily support and troubleshooting for all production databases, performance monitoring and fine tuning, designing and implementing backup and disaster recovery plans for every client, including implementation of Hot Standby, upgrading from Oracle 8i to 9i with complete data transportation, custom modeled databases based on clients requirements. Acted as liaison for multiple clients such as Pfizer, Verizon, AT T, Citibank, Wells Fargo and Chase.

Confidential

Senior DBA/Database Architect

For a banking/healthcare solutions application service provider responsible for the physical and logical design, development, installation, integrity and maintenance of the various database environments on Sun Solaris, IBM AIX and Windows NT/2000 platforms. The environment consists of Oracle, DB2 and Cache databases that act as a data tier for banking/financial and healthcare enterprise applications as well as a data warehouse. Daily responsibilities included data structural design to comply with HIPAA and HCFA regulations logical, physical and dimensional database design, modeling, creating, and modifying databases database security setup and management converting DB2, SQL Server, Sybase, SQL Anywhere Databases to Oracle, database upgrades, backup and recovery ad-hoc technical support of existing databases.

Confidential

Senior Oracle DBA

For a leading NASDAQ market-maker was responsible for logical and physical design, development, implementation, maintenance and support of Oracle database environment that supports all company's trading activities as well as Data Warehouse for intelligent data mining. Worked closely with the members of application development team in modeling, planning, deployment and maintenance of Oracle databases and application releases. Daily responsibilities included database performance tuning, security monitoring, physical database design, performing upgrades, providing production support, developing test plans, hot/cold backups and recovery.

Confidential

Oracle DBA

As a member of Oracle DBA Team responsible for maintenance and support of Citibank's Oracle databases worldwide. Scheduling and performing automated backup, database recovery, resource, space and user security management, application and database tuning on Unix platforms SUN/SOLARIS, HP . Responsibilities included technical support of all production databases, DBA tasks to assist developers, installation and configuration of Oracle Server and tools on various client sites.

Also participated in design, development and implementation of Oracle DB used for tracking and reporting all the changes being made in all banking software for Y2K compliance. Responsibilities included primary storage space structure table spaces primary objects tables, views, indexes , DB users, constraints. Utilized PL/SQL , Advances SQL and SQL Loader scripts for preparing data feed processes from other systems into Oracle DB to record all the changes being made in the code throughout all applications.

Confidential

Oracle DBA

Participated in design, development and implementation of several Oracle DB used for Software Co. technical support testing. Assisted with Progress/Oracle data conversion process including writing and executing various data load procedures using SQL Loader and Export /Import Utilities. Performed Technical support for existing applications written in Progress and used with Oracle DB, resolved problems with miscommunication between Oracle DB and Progress written Software Code analysis, Debugging and suggesting improvements and preventions of data related errors. Maintained customer databases. Provided training to new customers.

Confidential

Oracle Programmer

Involved in programming, testing and implementing all in-house applications using Oracle Forms 4.0 and 4.5. Created applications to allow preparation and maintenance of ship-to invoices for security equipment as well as application for Human Recourses Department. Those applications included enhanced search facilities, which provided user with a multi-criteria search. Each application included multiple verification procedures with an extensive use of PL/SQL units, inter-application libraries containing functions, procedures and packages. Performed minor improvements of existing programs in area o fuser operation support.