SUMMARY:

• SQL Server Database Administration/Developer Professional with over 7 years of contracting experience within a Technical environment. Strong ability to quickly adapt to new environments and function as a team player. Highly proficient in configurations and programming technologies.
• Experience with implementation of disaster recovery (DR) and strategy planning
• Maintained understanding of company’s hardware/software Confidential policies and procedures, as well as enterprise architecture
• The ability to write and troubleshoot SQL Code and design (stored procedures, tables, views)
• Trouble - shoot poor performing stored procedures, tune database & query performance.
• Provide database design assistance for system enhancements and new systems development
• Experience with delivering high availability solutions using database mirroring, log shipping and server clustering in a SQL SERVER 2005,2008,2008R2, 2012,2014 environment
• Experience with implementation of Confidential and recovery strategies in SQL SERVER 2005/2008/2008 R2 2012,2014environments.
• Create & review databases and coordinate changes during deployment.
• Provide data entry, storage, and retrieval techniques and technologies; integrate databases into software systems.
• Management of high performance production CLUSTERED SQL SERVER database instances using ACTIVE-PASSIVE Clustering
• Wrote conversion scripts using SQL, PL/SQL, stored procedures, functions and packages to migrate data from SQL server database to Oracle database.
• Experience in a multi-site environment data center environment clustered environment
• Proficient in logical and physical database modeling
• Setup and administration of SQL SERVER database Confidential environments by assigning permissions on Server Securable to principals
• Strong in SQL SERVER scripting and creating Packages, stored procedures and functions using T-SQL in a SQL SERVER2000/ 2005/2008/2008 R2 environments
• Extensive knowledge in Microsoft SQL Server databases, as well as SSIS, DTS packages, T-SQL, performance tuning, database design
• Experience with cross-platform database migration and database instance consolidation
• Experience with database upgrades and applying service packs
• Prepared data load files and complete uploads for Confidential and other auxiliary systems in a highly dynamic environment
• Knowledge of other databases like MySQL, Oracle, and In-memory databases
• Experience in creating, monitoring, Confidential, recovery, performance and tuning SQL Server databases in a multi-platform environment.
• Experience with the Always On AVAILABILITY, Clustering, database Mirroring, Log shipping and Replication. Experience in SQL Server and Windows performance tuning and optimization in 2008R2, 2012
• Update and maintain job knowledge by participating in education, reading detail oriented publications, maintaining personal networks, share knowledge with other IT staff
• Experience with the Confidential transformation and Load processes
• Ability to install and configure SQL Server 2008, 2008r2, 2012 and 2014.
• Customer service focuses with strong interpersonal and communication skills.

AREAS OF EXPERTISE:

• Data Migration
• Data Performance Tuning
• Confidential and Recovery
• Data Warehousing
• Database Upgrades
• High Availability
• Database Monitoring
• Database Confidential
• Disaster Recovery

TECHNICAL EXPERTISE:

Tools: Confidential Utility, SQL Lite Speed, and Red gate ( Confidential - pro7) T-SQL & ANSI SQL

Operating Systems: Windows 2000/2003/2008/2008 R2/2012/2014 Server

PROFESSIONAL EXPERIENCE:

Confidential, Jacksonville, Florida

SQL Server DBA

Responsibilities:

• Implemented and enforced appropriate Confidential measures for the database
• Assimilated organizational objectives into operational action plans.
• Knowledge and experience with capacity planning as it pertains to databases.
• Developed, tested, and maintained a Confidential and recovery process to ensure proper system continuity in the case of an unforeseen event.
• Assisted in development of a data warehouse that is similar to a feed repository of agent and merchant financial
• Responsible for all technical and operational activities associated with the DBA function(s) in a HIGH-AVAILABILITY and complex RDBMS environment.. Managed all aspects of database systems analysis including design, development, installation, and maintenance.
• Wrote complex relational database queries and query optimization for very large datasets.
• Made changes to production databases, such as creating new accounts, scheduling jobs, password changes, and modifications to server configurations.
• Worked closely with BI analysts to deliver effective global BI architecture in a timely manner.
• Installed database applications on servers and develop installation procedures for client installations to be performed by the desktop support staff as requested or required
• Experience with Data Transformation, Data Warehousing, and Data center
• Migrate SQL server instances between Virtual servers
• Extensive experience with VMWare and SQL Server virtualized databases

Confidential, Brentwood, TN

SQL Server DBA /Developer

Responsibilities:

• Managed all aspects of database systems analysis including design, development, installation, and maintenance.
• Wrote complex relational database queries and query optimization for very large datasets.
• Made changes to production databases, such as creating new accounts, scheduling jobs, password changes, and modifications to server configurations.
• Worked closely with BI analysts to deliver effective global BI architecture in a timely manner.
• Installed database applications on servers and develop installation procedures for client installations to be performed by the desktop support staff as requested or required
• Proactively monitored, identified, isolated and resolved server problems to avoid impact on the business.
• Monitored server activities, I/O, memory usage using system monitor/PROFILER to determine the cause of database/application slowness. Established data and user Confidential policies.
• Maintained and optimized Company’s transactional database via proper INDEX usage, de-fragmentation, and statistics updates, etc. Analyzed future disk space requirements, and usage to project hardware upgrade needs.
• Managed night job data processing for ongoing success- troubleshoot and rectify any production related issues.
• Designed, developed and troubleshooting SSIS packages that implement complex ETL processes.
• Implemented and enforced appropriate Confidential measures for the database.
• Designed and developed ETL solutions as well as debugging, monitoring and troubleshooting ETL solutions
• Generated trend analysis reports to proactively project resource requirements
• Built and support database models to support ETL, reports, dashboards, reports and BI packages
• Assisted users with problems and resolves issues independently
• Create & review databases and coordinate changes during deployment.
• Created test plans, test cases, test scripts and performs testing of the BI and related environments
• Developed and/or maintenance of SSIS packages, SSRS reports, and T-SQL processes.
• Deployed of SQL Server SSIS packages, SSRS reports, and T-SQL code to QA and production environments.
• Researched and stayed current with SQL Server,PL/SQL methodologies and new technologies.
• Tools/ Platform: SQL Server 2005, 2008, 2008R2, 2012,2014,Active/Active and Active/ Passive cluster, Database mirroring, Database mail, DTS, SSIS, SSRS, Confidential /Restore, DR plans, Cog no’s reporting Services, Always On Availability and with MS EXCEL

Confidential, Atlanta, GA

SQL Server Database Administrator

Responsibilities:

• Developed and maintained ETL scripts for efficiently loading and extracting data from the database when necessary.
• Developed DTS/SSIS packages to perform ETL operations from various data sources.
• Performed and monitored all database backups and restore database in response to minor and/or major database failures.
• Implemented and enforced appropriate Confidential measures for the database.
• Designed and developed ETL solutions as well as debugging, monitoring and troubleshooting ETL solutions
• Generated trend analysis reports to proactively project resource requirements.
• Developed, tested, and maintained a Confidential and recovery process to ensure proper system continuity in the case of an unforeseen event.
• Provided 24 X 7 production database support to help resolve production and application related issues(Sev1/se2)
• Responsible for all technical and operational activities associated with the DBA function(s) in a high-availability and complex RDBMS environment.
• Prepared data load files and complete uploads for Confidential and other auxiliary systems in a highly dynamic environment
• Managed all aspects of database systems analysis including design, development, installation, and maintenance.
• Wrote complex relational database queries and query optimization for very large datasets.
• Experience with Microsoft SQL Server database mirroring, log shipping and replication. Experience in SQL Server and Windows performance tuning and optimization in 2005, 2008, 2008R2, 2012.
• Worked closely with BI analysts to deliver effective global BI architecture in a timely manner.
• Proactively monitored, identified, isolated and resolved server problems to avoid impact on the business.
• Monitored server activities, I/O, memory usage using system monitor/PROFILER to determine the cause of database/application slowness. Established data and user Confidential policies.
• Maintained and optimized Company’s transactional database via proper INDEX usage, de-fragmentation, and statistics updates, etc. Analyzed future disk space requirements, and usage to project hardware upgrade needs.
• Managed night job data processing for ongoing success- troubleshoot and rectify any production related issues. .

Confidential, Atlanta, GA

SQL-Server Database Administrator

Responsibilities:

• Developed and maintained ETL scripts for efficiently loading and extracting data from the database when necessary.
• Ensured that database solutions for application systems are developed in a way that complies with architectural standards and established methodologies and practices.
• Installed, configured, and administer Oracle and Microsoft SQL database instances.
• The ability to OPTIMIZE stored procedures, performance tuning and index tuning using index tuning wizards and SQL Profiler.
• Participated in development and execution of Finance team key profitability ANALYSISand REPORTING objectives for the business portfolios
• The ability to write and troubleshoot SQL Code and design (stored procedures, tables, views)
• The ability to document standard operational procedures.
• The ability to CREATE data dictionary and Microsoft Visio diagrams for current production databases.
• Understood current capacity issues and the capacity planning processes.
• Participated in Disaster Recovery exercises (if available remotely).
• Provide Daily status reports of the work activity to Project managers

Tools: / Platform: SQL Server2000, 2003, 2005, 2008, 2008R2, Active/Active and Active/ Passive cluster.