Summary of qualifications

Over 18years of experience including 13 years as a Database administrator DBA in a development and Production support environment. Experienced with high transaction and high volume enterprise environments, in both Physical and Virtual Environments.Experienced with databases that bring in 140 million transactions per day in very complex and dynamic environments where five-nine uptime is mandatory. Experienced with Multi-terabyte databases on Microsoft Cluster Services and SQL Clustering Active-Active/Active-Passive experience, with building and Designing Windows 2008 Server cluster.Skilled in designing, installing, configuring and implementing various DBMS including SQL Server Enterprise, Amazon Redshift and Oracle Enterprise in a Windows and Unix Environment. Also possess 2 years of SAN Engineer Experience managing over a petabyte of data.

DBA Skills

Applications Languages

Protocols Hardware

Experience

Manage Enterprise Database Environments in a fullyVirtualized Environment, Which Consist of a 4 node SQL SERVER 2012 Databases Environment. for a Global Leader in the Payment Processing and reporting solutions that assist clients such as Visa,Mastercard and American Express discover etc.. Responsibilities include Enhance database performance, perform restores, implement recovery procedures, handle performance tuning and conduct regular system backups. Ensure technical and functional designs meet business requirements.

Key projects:

• Evaluate Current Disaster Recovery Implementation peer to peer replication and implement improvements
• Responsible for Code deployments and Stored procedure performance tuning .
• Responsible for Planning ,Designing and Implementing new Disaster Recovery Initiative using SQL Server Always ON Adding Replicas to Local Atlanta Datacenter and Austin Datacenters to provide High availability and DR for Critical Organizational Databases
• Responsible for performance tuning and managing a high volume high transaction environment loading data into and from Amazon form various DBMS or flat files etc
• Other duties include Managing partitions, space, security and jobs
• Manage Database Backups and Restores, Conduct Database Consistency Checks , Verify Backups

Manage Enterprise Database Environments in Physical and Virtual Environments, Which Consist of a Mixture of SQL SERVER Databases, AMAZON REDSHIFT, and MYSQL database for a Global Leader in the Search Engine Optimization and reporting solutions that assist organizations such as APPLE, JC Penny, and American Express achieve their online marketing goals. Responsibilities include Enhance database performance, perform restores, implement recovery procedures, handle performance tuning and conduct regular system backups. Ensure technical and functional designs meet business requirements.

Key projects:

• Serve as a Lead DBA/ Mentor for a group of 5 Database Administrators, 8 Database Developers and 10 Support Personnel
• Responsible for planning and implementing an international Datacenter migrations and consolidation project this consist of moving over 50 Terabytes of data from India and Belgium to a State of the art datacenter in Amsterdam with minimal down time.
• Responsible for maintaining a group of SQL 2008/2012 Enterprise Edition Active-Active Clusters running on Windows Server 2008 with databases ranging in sizes from 1TB to 500TB
• Responsible for Planning ,Designing and Implementing Disaster Recovery Initiative using SQL Server Always ON Adding Replicas to Local Atlanta Datacenter and Las Vegas to provide High availability and DR for Critical Organizational Databases
• Responsible for maintaining supporting Amazon Redshift Cluster 10 nodes 1 Petabyte of data
• Responsible for performance tuning and managing a high volume high transaction environment loading data into and from Amazon form various DBMS or flat files etc
• Other duties include Managing partitions, space, security and jobs
• Manage Database Backups and Restores, Conduct Database Consistency Checks , Verify Backups
• Manage fragmentation on indexes, Manage Partitions , Capacity Planning
• Create Manage, expand LUNS Using EMC Clarion SAN, using Power path Administrator
• Setup Manage Transactional Replication Across Multiple Publishers, Subscribers, Database Mirroring with a Witness Server.
• Work with offshore and onshore resources for maximum uptime and system performance
• Create /Review Rewrite Complex Stored Procedures, Views and Functions.
• Work with development and third party vendors to install patches and updates to various applications
• Trouble shoots website and job failures for end users and customers.
• On call 24/7

Manage SQL Server Enterprise Environments for a National Leader in theTransaction Based Marketing and reporting solutions that work directly forsome of the top Financial institutions in the Nation. Confidential Responsibilities includesprotecting sensitive data, Ensure that all security patches have been applied while also assuring that online banking user experience is optimal. Other duties include Enhancing database performance, perform restores, implement disaster recovery procedures, handle performance tuning and conduct regular system backups. Ensure technical and functional designs meet business requirements.

Key projects:

• Serve as a Subject Matter Expert/ Lead DBA/Consultant for several financial institutions Confidential .
• Responsible for maintaining a group of SQL 2008 Enterprise Edition Active-Passive Clusters running on Windows Server 2008 with databases ranging in sizes from 500GB to 10TB
• Responsible for performance tuning and managing a high volume high transaction environment Managing table and index compression and Space for internal and External Clients
• Manage Database Backups and Restores, Conduct Database Consistency Checks , Verify Backups
• Manage fragmentation on indexes, Manage Partitions , Capacity Planning
• Create Manage, expand LUNS Using EMC Clarion SAN, using Power path Administrator
• Setup Manage Transactional Replication Across Multiple Publishers, Subscriberswhile also building a custom monitoring solution to notify specific teams with any latency issues or errors with Replication.
• Create /Review Rewrite Complex Stored Procedures, Views and Functions.
• Work with Clients I.T. staff to install upgrades and patches to online banking sites
• On call 24/7

Manage SQL Server Enterprise Environments for a Global Leader in the Search Engine Optimization and reporting solutions that assist organizations such as APPLE, JC Penny, and American Express achieve their online marketing goals. Responsibilities include Enhance database performance, perform restores, implement recovery procedures, handle performance tuning and conduct regular system backups. Ensure technical and functional designs meet business requirements.

Key projects:

• Serve as a Lead DBA/ Mentor for a group of 4 Database Administrators, 6 Database Developers and 10 Application Developers.
• Responsible for maintaining a group of SQL 2008 Enterprise Edition Active-Active Clusters running on Windows Server 2008 with databases ranging in sizes from 600GB to 5TB
• Responsible for performance tuning and managing a high volume high transaction environment 140 million transactions a day Other duties include Managing partitions, space, security and jobs
• Manage Database Backups and Restores, Conduct Database Consistency Checks , Verify Backups
• Manage fragmentation on indexes, Manage Partitions , Capacity Planning
• Create Manage, expand LUNS Using EMC Clarion SAN, using Power path Administrator
• Setup Manage Transactional Replication Across Multiple Publishers, Subscribers, Database Mirroring with a Witness Server.
• Also Responsible for maintaining and Managing out Sister Company's Net mining group of SQL Server 2005 Enterprise Edition Active Passive Clusters
• Create /Review Rewrite Complex Stored Procedures, Views and Functions.
• Work with development and third party vendors to install patches and updates to various applications
• Trouble shoots website and job failures for end users and customers.
• On call 24/7

Manage SQL Server Environment for a top 25 health information technology company. Other duties include designing and implementing a Disaster Recovery Plan to several of our off site Datacenters. Responsibilities include Enhance database performance perform backups and restores using Snap manager for SQL Server and Oracle, Performance tuning and optimizing Preexisting Stored Procedure's.Support various business groups throughout the organization.

Key projects:

• Responsible for maintaining a group of 30 SQL Servers running 32 bit SQL Server Standard Edition and 5 SQL Servers running 64 bit Enterprise Edition with the smallest database ranging from 25GB to 2TB
• Setup Standby SQL Servers for failover using Database Mirroring Technology
• Other duties include Performance tuning, Capacity Planning and performing database portioning on qualifying tables, Create /Review/ Complex Stored Procedures, views and functions
• Work with development and third party vendors to install patches and updates to various third party applications
• Trouble shoot and investigate slowness and failures for website and desktop applications throughout the organizations
• Travel to National Health port Sites and provide SQL Support for customers and third party vendors
• On Call 24/7
• Other Duties include Unix Administration adding users and deleting users, granting privileges mounting drives and resources, tuning the kernel and some light Oracle Database administration
• Responsible for maintain and managing the NAS NETAPP which currently stores over a Petabyte of data which includes 4 clustered filers and 5 other separate Filers. Duties include adding shelves, replacing drives creating and managing aggregates, volumes and LUNS. Manage backups using Snap Manager or Native OS ONTAP
• Upgrade the filer Operating system and bios to new version when they become available
• Setup CIFS and NFS shares and setup appropriate access for the users to access these shares
• Setup and manage Snap Mirror to send data to our offsite datacenters
• Provide Reports to senior management on performance statistics using Operation Manager

Develop Database applications for a leader in the national publication and distributor of free print and online consumer guides for the apartment and home industries.Evaluate user request for new or modified back office application enhancements EPICOR . Analyze and developing specifications to determine feasibility, cost and amount of time to complete the request. Other duties include facilitate training both individually and within group setting for employees and clients in regards to the use and upgrade of the application.

Key projects:

• Design and suggest modifications for internal back office applications to enhance performance and reliability.
• Rewrite legacy applications written in Visual Basic to C
• Write complex stored procedures and views.
• Mentor and train junior members on the Team.
• Create, Design and support Crystal Reports in versions 10, 11 for the Accounting and Finance Departments
• Optimize Database stored procedures and triggers to improve performance issues and bottle necks
• Assist the on Staff DBA with Database related issues excessive blocking, lock escalation, enforcing database security
• Trouble shoots website and job failures for end users and customers.

I Worked as Database developer/Consultant for a national information technology company that services over 2300 clients across the nation.This project consists of Analysis of the current web application and suggesting an upgrade path to an entirely new solution. Other duties include Traveling and meeting with third party vendors to go over RFPs and translating the technical language to the President and Vice President of the client and also giving my recommendations.

Key projects:

• Serve as an internal SQL Consultant for the client Crescent Mortgage
• Travel to Vendor Sites and Consult with Software Architects on behalf of the client.
• Mentor Junior DBA on SQL Server 2005 advances features trouble shoot Replication issues
• Create Database Partitions, Partition Functions and Partition Schemas.
• Setup Database Snapshot for Reporting Services 2005
• Design Reports using Reporting Services 2005 for Accounting Departments and Finance
• Deploy, Publish and Schedule Reports Using Reporting Services, security
• Write/Rewrite Stored Procedures, views, functions to improve performance issues and bottlenecks

Perform duties as a Database Administrator for a leader in the insurance industry that services thousands of clients across the nation. Provide 24/7 support administering 10 production servers which serviced over a million transactions per day.

Key projects:

• Responsible for Maintaining a group of 10 SQL Servers Production, Development and Test Environments
• Perform database improvements, upgrades, and repairs for databases that consist of millions of Rows of data.
• Manage permissions and grant access to development and end users.
• Develop complex Stored Procedures, Triggers, Views, and DTS Packages.
• Cluster installation, Configuration and trouble shooting
• Trouble shoot website and desktop application failures
• Design Reports using Crystal Reports 10, 11 for Accounting Departments and Finance
• Publish and Schedule Reports Using Business Objects XI
• Create Jobs utilizing SQL LiteSpeed to backup and compress database backups up to 55 gigs
• On call 24/7

Experience

Manage SQL Server Environment for a top consulting firm in a Datacenter hosted environment.Other duties include traveling to client's sites across the nation, andinterviewing clients.Gather information regarding the legacy system. Perform analysis on the legacy systems and create processes utilizing DTS and SSIS to export data while alsode-duping and cleansing the data before importing into the newly developed application LAMPS.Other duties include installing, configuring Windows 2003, SQL Server 2000, 2005 using best practices, also act as tier 3 support for all server or database related issues.

Key projects:

• Serve as an internal SQL Resource for a Group of 12 Developers
• Recommend, schedule, and perform database improvements, upgrades, and repairs.
• Develop complex Stored Procedures, Triggers, Views, and DTS Packages.
• Perform/monitor system backups and recovery for external clients.
• Responsible for Maintaining, Supporting, and Tuning Production, Test, Development and Demo Databases.
• Design Schema upgrades to support code changes in the application for existing clients
• Responsible for trouble shooting, configuring transactional Replication for our multi company clients.
• Responsible for converting clients legacy data
• Other Responsibilities include reviewing SQL Code, making sure other developers where checking existing code into SQL Source Safe.
• Developing client Server Applications using C , ADO.net and SQL 2000
• Debugging, supporting and maintaining Client Server/Web Applications written in C and SQL 2000
• Developing Financial, reports using Microsoft Reporting Services and Crystal Reports

I worked as a Lead developer for a national leader in the Online Education and career-oriented certificate and degree programs in criminal justice, healthcare, business administration, information technology, and fashion design as well as many other fields. This project consist of Receiving training on a third party application Image Now and planning, installing , implementing, integrating and testing the solution to all of our schools across the nation, while also designing training materials and provide formal training for staff and end users. Other duties include leading a team of developers to design and create applications to be used for internal and external clients.

Key projects:

• Responsible For developing Client Server Applications using Visual Basic.Net , C , ADO.net and SQL 2000
• Responsibilities also include debugging, supporting and maintaining Client Server Applications written in Visual basic 6 and SQL 7, 2000
• Other Duties include upgrading Client Server Applications written in VBA, Visual Basic and ASP to the .Net Architecture.
• Also responsible for developing Financial, Budget, Management reports using Crystal Reports
• Also responsible for writing Several Complex Stored Procedures and Stored Procedures using XML
• Also Responsible for managing several Document imaging Projects which included analysis and design of the Accounts Payable System and Financial Aid Imaging System
• Responsible for designing workflow and approval process for the imaging systems
• Responsible for scripting functions in the Imaging System for updating database records using I script JavaScript

Experience

I worked as a programmer for a global leader in manufacturers and marketers of tissue, packaging, paper, pulp and building products. The project consists of SQL database development and some front end development as well for GP internal Information Resources Group.

Key projects:

• Responsible For Building Web Applications using Visual Basic.Net , C , ADO.net and ASP.net
• Responsibilities also include enhancing, supporting and maintaining Client Server Applications written in Visual basic 6 and SQL 7, 2000
• Other Duties include upgrading Client Server Applications written in VBA, Visual Basic and ASP to the .Net Architecture.
• Also responsible for developing Financial, Budget, Management reports using Active Reports Professional and Active Reports.Net
• Also responsible for writing Several Complex Stored Procedures

I worked as a SQL developer for the sixth largest integrated manufacturer of poultry producer in the nation. The project consist of SQL development with the mentoring of junior developers

Key projects:

• Responsible for new Crystal Reports development which consists of gathering user requirements and creating custom reports based on the users specifications.
• Responsible for duties include functional testing, stress testing, testing for data accuracy, meeting with the user and presenting the completed report with documentation followed by training.
• Serve as a Developer on the Applications Group.
• Duties include writing PLSQL statements, creating database Views, Packages, and Stored Procedures, gathering user requirements, and developing applications based on their specifications and Departmental needs.
• Responsible for supporting and enhancing existing Seagate Crystal Reports and monitoring Seagate Info Desktop to ensure users are receiving reports expeditiously.
• In addition to my core job functions, I am also responsible for supervising junior Crystal Developers.
• development and QA to resolve all database related issues.

Key projects:

• Responsible for designing, implementing and supporting various customized reports for customers using Transact SQL and Seagate Crystal Reports, which also included Mentoring Jr. Crystal Report writers.
• Served as a technical consultant for the entire Technical Support, Professional Services, and two Sales Divisions.
• Duties include overseeing a team of Senior Analyst with steps to resolving high-level technical problems.
• Served as a liaison to the Development and Quality Assurance group by reporting product deficiencies and suggesting product enhancements and/or new features.
• Developed SQL stored procedures views and triggers, create and rebuild indexes, perform backup and recovery of databases, create and truncate tables, import, export data from tables, and develop database maintenance plans.
• Traveled domestically to customer sites i.e., Wyeth-Ayerst Pharmaceutical, American Red Cross, GE Capital Mortgage, Greater Baltimore Medical Center, COX Communications, UPS United Parcel Service, etc. to provide technical consultation to C-level clients.
• Provide senior level technical support for internal support analysts, which included but were not limited to having advanced knowledge of SQL server including: Installing, Configuring and Troubleshooting SQL Server 6.5 and 7.0, also responsible for Upgrading Existing SQL 6.5 Servers to SQL 7.0. In a Windows NT Workstation/Server Environment.
• Duties also include of having extensive knowledge of Windows NT Server, Crystal Reports, NT Workstations, firewalls and phone systems.
• Also well understanding of our products and how it interacts on different platforms with different network protocols.
• Managed, supervised, and trained support staff and/or junior analysts utilizing Microsoft NT, MS Exchange Server, and MS Internet Information Server.
• 2000 Leader Award, Telemate.Net Software, Inc.