SUMMARY:

Over the last 21 years of being in Database Administration I had to Manage, Operate, maintain, and administer database servers, hardware and software in support of network management platforms; provide technical problem solving for customer computer support of database applications; Develop, implement, upgrade and maintain Microsoft SQL Server, DB2/ZOS, UDB on AIX, MYSQL, Oracle, UNIX based and LINUX based databases using code for development which includes SQL, and T - SQL scripts, Troubleshoot issues with existing or developed systems, work with the appropriate resources to resolve problems, Develop database interfaces to corporate databases and maintain and design data warehouse systems. I have also managed teams ranging from 6 to 10 people through various positions over the years. I specialize in database performance and have been contracted out from many firms to tune their systems. Some of the firms include IBM, Price Waterhouse-Coopers and Ernest and Young. I have been doing this from 1997 until present time. I am also a system integrator and specialize in data migration.

SPECIFIC SKILLS & KNOWLEDGE:

Hardware: IBM, IBM Compatible PC’s, Sun, HP

Software: DB2 OS/390, Z/OS, SQL, SPUFI, TSO, QMF, JCL, Oracle

RDBMS: Version 7.3,8 & 8I, Oracle forms V4.5, Windows NT, MS Windows, Visual Basic V5Access 2002 Office 2000, Clarify, Visual Source-Safe, Changeman, BMC ToolsMVS-OS/390, Platinum Tools, Endeavor, Data Warehousing, Data SharingCA Insight, SQL Server Version 6.5, V7, 2000, 2005 and 2008, VSAM, Enterprise Manager, Top Session, OLAP, Quest tools for Oracle, Unix, DB2 Connect, Shadow Direct, JD Edwards Administration, Quest Tool package, UDB on Sun Solaris Version 7.2 and 8.1 Embarcadero Tool Set for UDB and SQL Server, RemedyInformatica, IBM DPROPR, Idera Tool Suite for SQl Server, Red Gate SQL Server toolbeltSCOM monitor for SQL Server, Confio Ignite8 Monitor for SQL ServerNetApp and EMC technologies, Oracle Golden Gate 12C

PROFESSIONAL EXPERIENCE:

Confidential, Raleigh-Durham, North Carolina

Sr. Database Administrator for SQL Server and DB2 ZOS, Architect and Lead Engineer

Responsibilities:

• A highly motivated and committed IT Professional with over 20 years of solid experience in Designing, Implementing and Administering MS SQL Servers in Production, Test and Development environments.
• SQL Server DBA experience in IT, Banking, Mortgage, Finance, Telecom Domains and Medical.
• Practical experience on SQL Server 2012/2014 Alwayson Technology flavors like Standalone SQL Instance+AG, Alwayson FCI+AG including WSFC creation.
• Good professional experience and outstanding knowledge of high availability SQL Server solutions, including Log shipping, Transactional Replication, Database Mirroring and Server Failover clustering.
• Good understanding of Powershell and hands on using of it on SQL Environment.
• Good Exposure to new features in SQL Server 2012 like AlwaysOn High Availability Technology, Contained Databases etc..
• Exposure to SQL Server 2014 new features like in-memory technology, SSD Buffer Pool Extensions etc.
• Experience in MS SQL Server configuration, Performance Tuning, Query Optimization, System Optimization and consistency Checks.
• Expertise on Shared Infrastructure Administration.
• Exposure to SQL Azure on Microsoft Azure VMs.
• Good Experience in Administering SQL Servers on Virtual machines like on VMWare environments. Also good understanding of technical terminology surrounding Virtual Machines.
• Good experience on tools like Microsoft SCOM, BMC Remedy ITSM tool, Foglight, SQL Litespeed and Precise.
• Good experience in installation, upgradation, Migration, service pack installation, database migrations and maintenance of SQL Server 2000/2005/2008/2012 database servers in windows environment.
• Expertise in creating Back-up/Recovery plan creation, DR Strategy documents creation, testing the restore and DR recovery strategies and participating in Periodic DR Exercises.
• Expertise in monitoring SQL Server Performance and troubleshooting. Good experience with SQL Server/Windows native tools like SQL Profiler, Database TuningAdvisor, Upgrade Advisor, Perormance monitor, powershell, SQLIOSIM etc.
• Experience in Designing, configuring and creating databases, tables, indexes, constraints, writing and debugging stored procedures, triggers, views, functions and cursors
• Experience in performing Database consistency checks using DBCC Utilities, Recompiling Stored Procedures and Index Maintenance.
• Experienced in Automating regular Database Maintenance tasks by creating Jobs and Alerts using the Database Mail and SQL Server Agent.
• Monitoring Databases and server, estimating the growth of the databases, and maintain Fill Factors.
• Managed day to day activities like creation of users, schemas, configuring permissions and assigning roles to users and implement data encryption.
• Expertise in implementing different types of Replication models such as Snapshot, Transactional.
• Experience in extracting and transforming data using Bulk Copy (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS) in MS SQL Server 2000/2005/2008/2012.
• Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.
• Good knowledge in SSIS and SSRS Installation, configuration and Administration.
• 24X7 on call support for Production databases, Troubleshooting and problem Solving.
• Good interpersonal Skills result oriented, hardworking with quest and zeal to learn new technologies.

Confidential, Raleigh, NC

Responsibilities:

• Setting up extended events monitoring using Confio Ignite for SQL Server across all production environments.
• Working with the SQL Team to fully document a strategic plan to move the current data center from Danville VA to Boston MA and implementing best practices to upgrade all SQL Server environment from 2005 and 2008R2 to SQL 2012
• Security implementation and cleanup of existing security model.
• Performance and Tuning recommendations for existing environments which included set up of DB maintenance.
• Full documentation of each SQL Server environment
• Security implementation and security cleanup

Confidential, Raleigh, NC

Senior Database Administrator, System Integrator and System Engineer

Responsibilities:

• Implemented Transparent Data Encryption (TDE) to comply with HIPPA requirements developed Database Backup and Restores using Transparent Data Encryption.
• Currently supporting a 50tb data warehouse and worked with Microsoft to set up what we call intellimaintenece (maintenance) for large data warehouses and setting up a management data warehouse using reporting services to report back to the business trending unit for future growth
• I am in the process of moving the DW/ETL current data warehouse off of SQL Server and SSIS to Teradata as our main Data Warehouse and implementing Informatica as our main ETL solution.
• Built out the entire Disaster Recover site and implemented high availability using disaster recovery (Utilizing SQL Servers High Performance asynchronous method)
• Develop and maintain ITIL V3 Standards and guidelines.
• Implement, configure, and troubleshoot database instances, replication, backup, partitions, storage, and access.
• Monitor and optimize system performance using index tuning, disk optimization, and ther methods.
• Set user privileges within the database environment.
• Ensure robust and resilient production capability to cost-effectively guarantee 99.9% availability.
• Responsible for capacity planning and hardware and software requisitions.
• Write/maintain scripts to automate database and windows functions and document work performed.
• Manage Systems/Databases within internal and external audit requirements (including SAS70) to ensure compliance
• Ensure that customer problems are dealt with expeditiously to maximize satisfaction.
• Oversee Database and Windows Server upgrades and overall maintenance.
• Train new technical staff to ensure effective on-boarding coaching and training customers, and support personnel.
• Implement database and Windows monitoring and make performance recommendations and assist developers write optimal code.
• All storage is being supported using NETAPP software across product lines.
• Work with Systems Engineers to install and configure Database Servers.
• Maintain and validate current Disaster Recovery practices.
• Develop and keep accurate documentation of processes, standards and baselines across SaaS environments, generating status updates of assigned projects and problems.
• Ensure adherence to all IT and department policy, processes and procedures, particularly security standards.
• Serve as highest level of technical escalation for SaaS system issues; work collaboratively with Support and Infrastructure teams, vendors and customers to rapidly restore service in case of service interruption.
• Perform root-cause analysis on service interruption and create recovery process and preventive measures.
• Participate in an on-call rotation that provides 24x7x365 coverage of mission critical systems.
• Interface with business stakeholders on all applicable projects.
• Act as main interface for Technical support team.
• Working with NetApp flex clone technology for developers to have 24x7 access to a current copy of all environments

Confidential, Tampa, Florida

Vice President/Senior Database Administrator

Responsibilities:

• Evaluate requirements for the relevancy to (and impact on) the databases.
• Database maintenance for Oracle and SQL Server, DB2 ZOS and UDB on AIX
• Data Warehouse design and development
• Perform database capacity planning. enforcement of referential integrity data synchronization across multiple environments data modeling techniques, notations and tools
• SSRS Reporting Services and DTS/SSIS
• Data flow diagrams
• ETL (Extract Transform and Load utility)
• Ensure that the system and software architectures properly address persistence.
• Performance tuning for all databases and stored procedures.
• Determine the appropriate database technology (relational extended relational or object database)
• Evaluate and select the database management systems to be incorporated into the application(s).
• Migration from SQL Server 2000 to SQL Server 2005 and SQL Server 2008 R2
• Data encryption for all applications.
• Database maintenance, logical and physical design
• Determine if existing database access software requires modification.
• Collaborate with others to determine the:
• Impact of database changes on the other systems
• Staff cost for making changes to the databases.
• Design and develop all security for all database systems
• Set up and implement disaster recovery in SQL SER DB2/ZOS, Oracle and UDB on AIX
• Perform platform assessment regarding proper support for the selected databases.
• Produce the database-related contents of the following and operations documentation:
• Deployment Plan
• Installation Manual
• Operations Manual