SUMMARY

• Oracle DBA wif over ten years of experience.
• Unique DBA, who started his career as a Developer
• AnExpert in Backup & Recovery
• Master of SQL performance tuning
• Certified SQL Server DBA(MSCA). Expert in T - SQL, Reporting Services (SSRS) and (SSIS)
• Clear concepts of internals - How a query travels from client to teh database & back.
• Rock solid in High Availability Solutions like RAC, Data Guard, Golden Gate& Oracle Streams.
• Innovative in using latest techniques using OEM Grid Control 12c and EXADATA for big shops.
• Strong in SQL, PL/SQL and writing Stored Procedures, Functions & Packages
• Well experienced in PostgreSQL. APEX HTML DB, PL/SQL Program Units, Forms & Reports Builder
• Oracle Certified for all Oracle Database versions starting from Oracle 8i to 12c.
• A team player and an expert in customer interfacing. Shell Scripting expertise in Linux & Unix
• A clear understanding of Big Data Hadoop files systems, like teh capture of weblogs data using Flume, creating Hive external tables, teh update of teh user profile wif key-values in teh NoSQL database. Data Warehouse data integration and running of R Analytics to predict future models
• Expert in Spark Scala language and engineering of Spark distributed data sets

PROFESSIONAL EXPERIENCE

Oracle DBA

Confidential, Brooklyn, NY

Responsibilities:

• Helped current DBAs to use OEM 12c Tuning Adviser as a tool for performance tuning.
• DBA support for Production, Development and QA databases running Oracle 11gR2.
• Performedquarterly Patching and maintenance of QA, Staging, and Development .
• Automated patch deploymentusing Enterprise Manager.
• Improved 24/7 alert and maintenance of databases by solelyconfigur ingOEM Alert Rules.
• Configured daily backup using Enterprise Manager.
• Added new devices to RAC Cluster s and wif ASM disk storage.
• Providing OS level support as Linux Admin as there are none.
• Improved workload times by configuring SQL Profiles on queries.

Oracle DBA

Confidential, New York, NY

Responsibilities:

• Supporting Ellucian Banner 9 ERP Applications wif Oracle 11g databases for Admission, HR, etc.
• Creating new Physical Standby databases for disaster recovery. Created documentation.
• Mentoring DBA team wif performance tuning of SQL queries while using OEM 13c.
• Created alert email system for databases and hosts using OEM 13c.
• Wrote scripts to startup and shutdown of teh databases, listeners and OEM Agents wif scripts.
• Cloned databases using RMAN DUBILICATE. It is required for migration to new hardware.
• Applied latest Security Patches to teh databases, OEM 13c OMS, Agents and Plugins.
• Configured daily online backups for databases using Cloud Control. Supported Museum App.

Oracle DBA Engineer

Confidential, New York, NY

Responsibilities:

• Worked as a Senior Oracle Database Administrator & Data Architect in Bank’s Proof of Concept Engineering Department to test and document Oracle new technologies and products.
• Served one year in Federal Reserve National IT as Production DBA at New Jersey location.
• Solely developed two in-house applications from scratch called Dashboard & Calendar. Applications used secure SSL HTTPS connections and Active Directory LDAP autantication. They were built using License free Oracle Application Express (APEX). Dashboard provided real-time status of hosts & databases. Managers used them to no information about applications and check teh current status of all servers. Live data pulled from Grid Control, Postwar databases wif local tables. BI Publisher used to publish formatted reports and customized forms.
• Set up Enterprise Manager EM12c Cloud Control wif Sun Enterprise Directory LDAP Autantication using WebLogic server. Integrated Oracle Ops Center 12c and Oracle VM.
• Wrote Partitioning Procedures for Data Warehouse application to partition data on daily, weekly and monthly basis. Procedures are running in all Production databases error free since Feb 2009.
• Implemented Oracle Wallet for secure database connections used by applications.
• Implemented Data Masking procedures in teh Markets Department. It is used to mask Production data wif real looking fake data, which used in Development environments.
• Established new rules for DBA access auditing in applications and databases.
• Installed six-node 11gR2 RAC cluster on AIX wif ASM, Grid Infrastructure wif RAC One Node databases. Set up disaster recovery wif Data Guard at three nodes cluster.
• Supported RAC and ASM and RAC One Node. Created services for users.
• Responsibilities include Production ProblemsDebugging and Performance Tuning of slow queries.
• Provided Tier-3 performance tuning support of Data Warehouse&OLTP slow query problems.
• Implemented Oracle Grid Control 11g wif Cold Failover Cluster (CFC) set up.
• Prepared storage pool of ASM disks for Oracle Automatic Storage Management ASM on a two node Linux cluster using Oracle ASMLib.
• Installed and configured Oracle Grid Infrastructure release 11.2 for RAC on two nodes Linux cluster. Configure ASM Disk Groups for OCR and Voting Disk files.
• Installed Oracle 11gR2 Real Application Clusters RAC software on thethree-node cluster. Created a RAC database using teh Database Configuration Assistant.

Oracle DBA

Confidential, New York, NY

Responsibilities:

• Consultant to help create RAC clusters on Linux wif ASM. Provide DR & high availability solutions.
• Cut down runtime for 90% of heavy queries from 10-20 minutes to under a second.
• Convinced DBA team to use EM12c for troubleshooting, admin & performance tuning.
• Resolved mysterious date timestamp issue relating to time zones of listeners and database.
• Introduced latest methods of SQL monitoring & tuning using EM12c. They were using old methods.
• Set up two nodes 11gR2 Linux Redhat 6.4 RAC Cluster wif ASM & Data Guard.
• Configured Single Node Standby database for a three node RAC.
• Cloned databases using RMAN Active Duplicate. Configured a 3-node Linux RAC Cluster
• Extended two nodes RAC cluster to three nodes & instances.
• Upgraded OEM 12c. Upgraded OMS, Repository& Agents.
• Provided OEM Read-only access to developers. Trained them to tune their queries themselves.
• Provided performance tuning of ATG book buying application wifout touching teh source code.
• Deployed ASM disk groups over Violin flash drives using 4K sector size blocks.
• Installed SQL Server 2014. Set up backups. Tuned SQL queries in Management Studio.

Oracle DBA

Confidential, Montvale, NJ

Responsibilities:

• Helped set up a zero-downtime disaster recovery system wif Exadata, Golden Gate& Active Data Guard for Confidential Corporation upgrade in Montvale, NJ.
• Created POC environment on Exadata X3 two RAC Clusters. Installed Golden Gate.
• Restricted privileged access to data using Database Vault and Audit Vault wif Advanced Security Options (ASO).
• Securedata at rest using Encrypted tablespaces wif a Database Wallet having a master key. Laid out Master Key rotation policies.
• Configured GDS (Global Data Service) Application to provide transparent servicefailover across multiple RAC clusters.
• Installed and configured Oracle Enterprise Manager 12c Cloud Control for monitoring.
• Migrated data from Mainframe Unisys 2200 to an Exadata5 -2 machine running 12c RAC cluster. Data sync using Golden Gate replication.
• DR useGolden Gate replication, Active Data Guard and ZDLRA (Zero Data Loss Recovery Appliance). It provides block-level backup sync at both primary and DR site.
• Configured Golden Gate replication using ACFS ASM shared afile system. Created Golden Gate resource in a RAC Cluster for failover.
• TrainAS400 staff to use Linux and Oracle Database 12c to maintain data.
• Provided solution to upgrade large 4 TB databases from Oracle 11g to 12c which had a physical standby database. Upgrade used plugin method of 12c package DBMS PDB.
• Secured primary data by creating an Oracle 12c Data Guard Active Standby database.
• Worked in Cloud connecting Exadata wif Oracle Big Data Appliance to bring Hadoop HDFS data into an Oracle database. Used Flume to extract web logs into HDFS and NoSQL databases. Created Hive JSON external tables. Joined them wif data warehouse external tables to integrate data. Ran R queries to analyze data and predict future models.
• Configured customized email notification system for all targets in Oracle Cloud Control 12c.
• ConfigureGolden Gate High Availability solution for Data Warehouse running over 11g RAC.
• Performed Oracle Golden Gate installation on teh source and target servers wif Data Pump.
• Loaded target tables wif Golden Gate Initial Direct Load and Direct Load to File methods.

Oracle & SQL ServerDBA

Confidential, New York, NY

Responsibilities:

• Served as a Production Apps DBA for Lawson E-Business Suite of Applications. Lead a team of Lawson Administrators and a team of developers building a homegrown application for student online evaluation exams.
• Played a vital role in company’s transition from Oracle 8i database infrastructure to the10g structure while upgrading from Lawson E-Business Suite of Applications from 7.2 to Lawson 9.0. Helped setup new Lawson supporting apps,me.e.,Image now, Document Express (MHC), Crystal Reports and custom apps to work wif WebSphere.
• Supported all NY-HQ databases along wif a fleet of 517 database servers all over teh USA and UK.
• Cut down Warehouse data availability time from 20 days to 5 days after redesigning outdated loading process. Installed and tested 11g wif new features for warehouse upgrade.
• Regularly loaded and maintained company Oracle data warehouse in Chicago.
• Every two weeks loaded data from hundreds of PostgreSQL database servers.
• Resolved many MS SQL Server 2005 database backup problems serving image keeping applications Power-Docs&Imagenow and company web URL filtering app Websense.
• Installed two nodes Oracle RAC cluster on Linux boxes wif 11g database.
• Configured Standby Database wif Data Guard using maximum protection.
• Created Shell scripts to run RMAN for daily backup of databases using Cron jobs.
• Lead a team of seven developers enhancing Benchmark and Newton applications storing data in Oracle and PostgreSQL. Helpthe developer team in troubleshooting queries.

Oracle Data Architect DBA

Confidential, New York, NY

Responsibilities:

• Worked as a Data Architect to design database models.
• Assisted developers in fine tuning SQL queries and writing efficient code.
• Successfully added five new applications in theinventory list. Lead multiple teams of software architects & developers in assisting Rational Rose DOM design. It helped in designing efficient database ERD models using Erwin 4.0.
• Lead a team of consultants from Mexico wif themigration of 45 J2EE and ETL applications fromiPlanet to JBoss application servers along wif database upgrades from 8i to 9i/10g. Moved data from Cincinnati to Englewood Cliffs, New Jersey.
• Completed a six-month project 42 days earlier than teh projected date. Installed MS SQL Server 2005 and configured user objects.
• Prevented a major crisis about thestandard process of restoring databases by finding out NOLOGGING tablespaces present in different environments including Production.

Oracle Developer &Jr.DBA

Confidential, New York, NY

Responsibilities:

• Configured a highly available “Zero downtime” system by setting replication wif materialized views on remote databases using database links. Created a package to update all production tables using DBMS MVIEW. Provided detailed logging wif theUTL FILE package.
• Build solid data defenses: Configured Encryption to store credit card numbers in theUTL RAW package. Improved security further by providing reverse encryption. Installed SQL Server 2005.
• Built new entry Forms providing weekly reports using Oracle Forms and Reports. Wrote Packages.
• Created a bulletproof secure system by creating individual users, roles, and privileges. Audit teh database objects by-access.Configured systematic purging of audit table.