• Database administrator DBA with 10 years of experience designing, coding, testing and supporting next-generation database solutions in Oracle enterprise and SQL Server environments. Proficient in an assortment of technologies, including Oracle 10g/11g, MS SQL Server, Oracle RMAN and Windows. DBA skills include:
• Experience with SQL 2000 2012, Oracle 10g/11g
• Expertise in Oracle Data Dump Utility
• Expertise in Oracle RMAN Backup / Recovery
• Expertise in T-SQL writing stored procedures, triggers and functions
• Expert in data transformation services like SSIS, DTS, BCP and Bulk Insert
• Worked on logical and physical database modeling suing ERWIN tools
• Experience in using DMVs and dynamic management functions for finding long running queries
• Worked on database and server consolidation efforts
• Having hands-on experience in DR planning and execution
• Worked on configuring SQL Server with minimum privileged access
• Worked on all database migration from SQL 2000 to SQL 2012
• Working knowledge in SSAS, SSRS and Clustering
• Strong experience in mentoring team members and writing documentation
• 24 x 7 On-call Support

System Upgrade

• Developed implemented a migration strategy for upgrading SQL 2000 and SQL 2005 t SQL 2008 R2.
• Created and drove the migration strategy t begin transformation t SSIS from the legacy Data Transformation Services DTS .

Performance Management

99.99 uptime on the database servers

System Integration

• Deployed complex end-to-end business intelligence solutions that delivered business value t functional organizations which has processed 247,452 documents since March 2008.
• Implemented a process t update a given number of award nominations and by doing s , it saved NASA approximately 92,000.00 if the NSSC Functional users had t update the FFPS records manually.

Database Tuning

• Due t resource contention, I researched options that could be utilized implemented on the database in which ReadCommitted Snapshot and Allow SnapShot Isolation features were implemented.
• Due t the fast pace growth of our Oracle-based Remedy 7.5 application, I lead the team t determine the course of action required. In cooperation with Remedy development team, it was determined that the following steps would be required:
• Table level changes would be required changing 8 LOB objects t VARCHAR2 in the Remedy Reporting instance.
• Migration of 3 million records the Remedy Reporting instance and during this migration, these LOB objects would be converted t VARCHAR2.
• Shrinking of the LOB segments with a space saving of 80GB.

Technical Training

Actively mentored, trained and supervised junior Database Administrators for several months t improve their MS SQL 2005 / 2008 and Server Side Integration Server skills.

Manage SQL Server 2008 R2 environment for CMS on the CDAT Central Data Abstraction Tool project . Enhance database performance, perform restores, implement recovery procedures, handle performance tuning and conduct regular system backups. Ensure technical and functional designs meet business requirements.

Responsibilities:

• Installed and administered Two-Node cluster Active/Passive on Windows 2008 R2 on SAN environment.
• Supported more than 15 production databases
• Extensively worked on Dynamic Management Views in SQL Server.
• Rebuilding / Monitoring the indexes at regular intervals for better performance.
• Recovering the databases from backup in disasters and implementing Point-in-Time Recovery solutions.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency using DMVs, SQL Profiler, SSMS, Database Engine Tuning Advisor DTA and Spotlight.
• Implemented the snapshot isolation levels on numbers databases.
• Responsible for monitoring and making recommendation for performance improvement and this involved index creation, index removal, index modification, file group modification and adding scheduled jobs t re-index and update statistics in databases.

Managed SQL Server and Oracle environments for the NASA Shared Service Center. Provided support for multiple agency-wide applications including Disaster Recovery planning, execution, database security, 24x7 support and database upgrades.

Responsibilities:

• Installed and administered all SQL Server databases instances and environments
• Installed and administered Oracle 10g / 11g environments supporting more than 15 production instances of which 2 instances were Clustered with Failsafe
• Recovering the databases from backup in disasters and implementing Point-in-Time Recovery solutions.
• Automated hot backups using Oracle RMAN.
• Exporting/Importing of Oracle Databases using Data Pump.
• Performed business analysis, technical analysis and system designs
• Managed the migration of SQL Server 2000 databases t SQL 2005, SQL 2005 t SQL 2008 R2 and SQL 2008 R2 t SQL 2012.
• Participating in the Oracle 10g t 11g upgrade.
• Rebuilding / Monitoring the indexes at regular intervals for better performance.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency using DMVs, SQL Profiler, SSMS, Database Engine Tuning Advisor DTA and Spotlight.
• Responsible for monitoring and making recommendation for performance improvement and this involved index creation, index removal, index modification, file group modification and adding scheduled jobs t re-index and update statistics in databases.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS
• Performed daily tasks including backup and restore by using SQL Server tools like SSMS, Profiler, SQL Agent and Database Engine Tuning Advisor
• Export / Import from other data sources like flat files using Import/Export through DTS/SSIS
• Created Linked Serves between SQL Server Oracle 10g/11g and created SSIS packages for data transfer between the environments.
• Applied Microsoft and Oracle security patches
• Supported the implementation of Microsoft TFS and SharePoint.
• Migrated COTS application from SQL 2005 Express t SQL 2005 Standard edition..
• ITIL knowledge and experience

Project lead on several high profile projects for NASA's Rocket Propulsion Test and Information System Directorate and LM Industrial Management Directorate utilizing client/server and web-based technologies.

Responsibilities:

• Experience in system level requirements analysis for projects that incorporates a wide range of development technologies, from client/server, web-based and database interfaces.
• Generated cost estimates schedules for projects based on requirements.
• Worked all phases of project development from gathering customer requirements through application development, delivery support.
• Primary point of contact for numerous applications.
• Provided technical support t team members relating t development and system administration.
• Successful development deployment of the FOD Gas Cylinder applications.

• Designing High Availability Database Solutions Using Microsoft SQL Server 2005 2788A
• Implementing and Maintaining Microsoft SQL Server 2005 Integration Services 2792A
• Maintaining a Microsoft SQL Server Database 2005 Database 2780B

• Vice-President of the Gulf Coast Down Syndrome Society GCDSS 2012
• President of the Gulf Coast Down Syndrome Society GCDSS 2013