SUMMARY

Certified Database Administrator with over thirteen years of proven performance and expertisein Information Technology. Experiencedprimarily in thedefense and also the financial industries. Proficient inproduction database administration, database security administration, technical troubleshooting and support and handling complex issues in a high stress environment.Skilled in determining system requirements and specifications for database and other database - related software installations, patching and upgrades.Able to communicate effectively with multifunctional teams, programmers and technical staff at all levels. Experienced in consulting with users, resolving problems and meeting specific technical and business needs.

Areas of Expertise:

Databases: Oracle 8i/9i/10g/11G, SQL Server 6.5 /2000, 2005, 2008, 2012, Sybase ASE, Access

Operating Systems:Sun Solaris/Linux Red Hat / Windows 2000 Server/ XP/98/NT

Application Software: OAS, OID, LDAP

Advanced Oracle Skills: Database Encryption, Net 8 Encryption, Audit Vault, Data Guard, Replication, RAC

Database Tools: Quest Toad, DBArtisan, OEM, Grid Control

Certifications: 8i Oracle Certified Professional, CompTiaSecurity, in the process of upgrading to Oracle 12C certification

Professional Experience:

Database Administrator

Confidential

• Performed administration and maintenance of 150 SQL Server Instances into PROD-QA-DEV-DR environments
• Setup, monitoring and maintenance of SQL Server data Replication
• Created and Configured SQL Server Data Servers, Physical Schemas, Logical Schemas, Models, Interfaces and Packages
• Created setup of STANDBY Disaster Recovery Server using custom Log Shipping and Backup Restore process
• Implemented Upgrades and Migrations of Thompson Reuters 24x7 SQL Server databases with minimum downtime for Data Center Migration usingDB Artisan
• Created user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups, assigning the users to particular groups within security compliances of Thompson Reuters and for Bloomberg
• Setup jobs and alerts for Backup Restore VLDB, re-indexing, integrity checks, database shrinking, transaction log growth monitoring and routine database maintenance processes
• Administered 24x7 Real Application Cluster RAC databases running on Cluster File system. Worked with senior DBA's for preparing cluster, configuring and Installation of Clusterware and OracleRAC on Red Hat Linux. Startup and Shutdown of Individual instances on RAC database using Enterprise Manager.
• Successfully performed Cross platform schema migration from Sybase ASE to Oracle 11G
• Created/Modified/Locked Logins and Users in Sybase Database
• Setup security, auditing compliance to Sarbanes-Oxley SOX and security best practices
• Certified and applied Oracle Quarterly security patches as per Bloomberg standards
• Converted production Excel version to Web Logic with a team of developers successfully deploying reports through Oracle reports and SSRS from an Oracle universe transactional data mart. Cut download time from 35 to 7 minutes
• Created Excel spreadsheets with VBA to obtain real time pricing from Bloomberg and Reuters
• Provided 24-7 support for primary users who are typically overnight traders and mortgage teams
• Wrote technical documentation explaining detailed steps taken of my database projects and tasks and also documented in detail steps on occurring issues and the steps I had taken to resolve them

Environment: SQL Server 2012, SQL Server 2008/ R2/2005, Sybase ASE 12.5, Oracle 11G, 12C Windows 2008, SAN, VM, RHEL 6

Senior Database Administrator

Confidential

• Responsible for Managing and Administering all Army Center of Substance Abuse Program ACSAP Oracle Databases in high security sensitive production, standby and development environments on Unix and Linux platforms
• Recognized by CIO and head of Army Center of Substance Abuse Program for introducing and implementing Transparent Data Encryption on Oracle 10G Production/development and standby database tables containing PII data, later introduced and successfully applied the new option Tablespace Encryption in Oracle 11G databases after upgrading databases to Oracle 11G
• Setup and Utilized Net 8 encryption for secure data transmissions over the network
• Successfully performedData Pump data migrations, exporting and importing encrypted Data, and for exporting and importing select data using queries in the exports on Oracle Production, Standby and Development databases
• Performed Backup and Recovery using RMAN, Flashback recovery, Transportable Tablespaces, and Data Pump tool
• Wrote Chron Jobs in Unix and Linux environments to Automate my cleanup and auto login shell scripts, data migrations and run backup scripts, also implemented automated backup strategy using the UNIX shell script CRON UTILITY
• Performed SQL Loader, export/import and data pump to load data in to tables
• Expertly upgraded the databases from Oracle 9i to Oracle 10g / 11g
• Successfully performed installations and configurations of Oracle 9i, 10g, 11g database, client and application server software on UNIX and RHEL platforms
• Applied Oracle database CPU and PSUpatches on all database and application servers on a quarterly basis
• Performed multiple database migrations from Production to standby and development using RMAN tool
• Remotely managed and maintained allACSAP Oracle 10G and 11G Databases on Windows 2000 server platformin Hawaii office
• Researched, introduced and Installed Oracle Audit Vault Server and client software, implemented auditing on all production databases
• Migrated table data from access to Oracle
• Performed RAC 11g,10g installation, administration and configuration in test environment, CRS using ASM in development environment
• Managed OAS, OID, LDAP onapplication servers
• Manage users, privileges, profiles and schemas using Grid Control of Oracle Enterprise Manager OEM
• Enhanced expertise in knowledge ofOracle Architecture, SGA, PGA, Binary structure, Listener, TNS Names, SQL Net, V, Logical and Physical databases design using tools like Erwin and Visio.
• Refresh schema using data pump Export/Import tool
• Implemented the Oracle 10.2.0.3 Physical Data Guard in Maximum performance mode for production system in case of disaster recovery, and to maintain primary and standby databases
• Took a logical backups of the entire archive database using import/export utility to have a variety of backup and recovery methods
• Created duplicate databases using RMAN duplicate, drop databases using RMAN Delete

Environment: Oracle 9i, 10G and 11G, SAN, RHEL 5, HP-UX, AIX, Sun Solaris, OEM, PL/SQL, TOAD, RMAN, TPROF, Explain plan, STATSPACK, SQL Loader

Database Administrator

Confidential

• Administered SQL Server and Oracle Databases in both the production, standby and development environment. Performedinstallations, upgrades, patching and maintenance checking the logs and rollback segments on a daily basis
• Analyzed vulnerabilities, planning and implementation of SQL Server security remediation
• Programmed in PL-SQL and T-SQL to perform the data Query functions in Aeronautics and Space Administration high security sensitive environments
• Performed database Migration from SQL Server 6.5 up to to SQL Server 2000
• Performed cross platform migrations from SQL Serveron Windows to Oracle on Linux using Embarcadero DB Artisan
• Created SQL Server Data Transformation Packages, scrubbing security sensitive data prior to moving from the production environment to development environment
• Utilized SQL Server agent to schedule backups for databases in development environment
• Used Oracle SQL-Plus, Microsoft SQL Query Analyzer, Toad and DB Artisan for database management, writing SQL, creating tables, creating users, creating roles, creating groups, and checking data
• Administered Unix based Cold Fusion Applications connecting to Oracle 9i and 10G Databases
• Administered Cold Fusion application files using Solaris 9. Including moving the files from server to server, setting permissions, extractions, and data migrations
• Applied DST and database patches to Oracle development and standby databases
• Follow policies, procedures and ITIL practices for incident, release, change, issues and requests
• Creation of Table space, Data files, Indexes, Rollback Segment and monitoring them.
• Configured scripts to monitor activity with database Implement Hot, Cold and Logical backup plans
• Designing and creating schema objects like Database tables, indexes, views, synonyms
• Responsible for writing database programming to Store/Retrieve the information from the database using T-SQL
• Wrote Stored Procedures according to specs and control files for input to SQL Loader utilities for loading data from external files into the Oracle database
• Extraction of data from different flat files into Oracle Database using SQL Loader and automated the process by using Basic Replication using materialized views
• Monitored the various database activities such as backup, error logs, space, object, performance, user and session monitoring to ensure proper capacity and availability for increased performance
• Performed Database and SQL tuning by using various Tools like STATSPACK, TKPROF, EXPLAIN PLAN, optimizer hints and SQL tuning advisor
• Investigated suspicious database activity using Auditing
• Worked on very large database VLDB of 2TB with 23 servers including 5 productions, 12 development databases

Environment: SQL Server 6.5, bit, SQL Server 2000, Windows 2003, VMWARE, SAN, .NET, MOM, SharePoint, BizTalk, Quest Diagnostic tools, Red-gate, SSIS, SSRS, ER/Studio

Oracle Database Administrator

Confidential

• Created a backup and recovery plan for company database
• Created and automated backup jobs using Oracle Recovery Manager RMAN
• Installed, configured and used Oracle Enterprise Manager for database tuning, capacity planning and performance management
• Created and maintained replica versions of database objects
• Created Oracle test databases for backup plan testing in development environment
• Performed database migrations from production to standby and development environments
• Managed exporting and importing of client data into Oracle database
• Held responsibility of On-Call 24x7 production DBA and application/development DBA and Oracle Support processes for technical requests through Meta link and other Support Procedures
• UNIX shell scripts for hot backups, SQL Loader, export and import of database
• Proficient knowledge in RMAN backup Full, incremental and cumulative and recovery, Incomplete recovery and disaster recovery
• Experience in using OEM, TOAD, SQL Developer and performing data migrations using Export/Import utility
• Performed Database and SQL tuning by using various Tools like STATSPACK, AWR, TKPROF, EXPLAIN PLAN, and optimizer hints
• Created, Configured and Set up RMAN Catalog databases and registering target databases with the Catalog
• Reporting and resolving all serious Oracle alert log messages
• Installed and Implemented Backup Recovery procedures. Implemented Hot and Cold Backups, Exports and Imports
• Created and Managed tablespaces, Tables, Views, Indexes, and Partitions
• Monitored the database, Managing sessions, listeners, underlying physical components against performance and availability thresholds
• Extensively used Oracle utilities -Export, Import, data pump and Sql loader etc
• Created physical databases, as well as the schemas and objects within the database
• Recovered successfully two production databases from RMAN backups due to an unexpected media failure resulting in data corruption errors and loss of control files

Environment: Oracle 8i, SQL Server 2000, Windows NT/2000, OEM, SQL PLUS, Quest TOAD software tools

Adjunct Instructor/ Web Team part time

Confidential

• Taught students Web Page design using XHTML, DHTML, Java Script and CSS via Sametime and in-class sessions.
• Developed entry level and advanced curricula on a wide range of Web development topics, consistently meeting tight deadlines. Subjects included:
• Basic networking for Web developers including secure file transfers for uploading their webpage content Troubleshooting and Bottleneck support Java Scripting Cascading Style Sheets Advanced Flash MX Database-driven website design Dynamic HTML
• Designed Website for LSites project, creating front end for MySQL using in PHP, DHTML, CSS and JavaScript.
• Developed and implemented Database Driven Websites for the JCTCS website.
• Managed all testing efforts including integration, product, regression and unit testing in multiple testing environments.