PROFESSIONAL SUMMARY:

• As an IT professional with the last 19 years as a SQL Server Database Administrator, my experiences have allowed me to not only become proficient in managing and tuning SQL server databases systems but also share my experience and knowledge with other in a Senior roll.
• This includes SQL server setup, database Data and log files location for better through put, Indexing for more efficient query, and T - SQL code review prior to deployment Along with performing sql server versions migration, I’ve also supported environments with 30 plus database servers with the largest database being over a terabyte in size.
• My position with Rosenthal Collins called for correcting several performance issues with critical database mirroring platforms. By using SSRS and Idera monitoring tools I’m able to provided management with further environment data that has allowed flexibility in planning for expected growth over the coming years by taking advantage of SQL Server 2008 R2, VM, and SAN technology at the time.
• I developed a new plan to migrate several legacy applications up from SQL 2008 to SQL 2016.In my time with Memorial Health University I had taken on an Oracle migration project to move an application from Oracle from 8i and 11G. While in my position at Confidential I moved several production SQL server databases from standalone server to our VM environment, and worked as part of the development team to develop a plan to migrate SQL 2008 R2 databases to SQL 2012. Along with my SQL DBA responsibilities at Confidential
• I was also learning Hadoop, and Mongo Big Data technologies, and I’m currently adding Azure and AWS to my knowledge base while taking online classes in order to finish my degree push since returning to Chicago.

TECHNICAL SKILLS:

SOFTWARE: (SQL 6.5 through SQL 2016) (SQL SSIS, SSAS, SSRS),(Oracle 8.1.7, 9.01, 11G), Oracle, ERWIN database designer, Windows, Embarcadero change manager and DB Artisan. Idera monitoring tools, Light Speed backup tools

PROFESSIONAL EXPERIENCE

Confidential

Sr, SQL Database Administrator

Responsibilities:

• Administer the 15 2008 SQL Servers that make up Production / QA / and Development. Design and manage the current sql server 2008 environment And complete the migration plan for moving production and development to a new SQL server 2016 clustered environment to and eliminate the current critical failover points.
• Update DR documentation, schedule and perform in-house and DR site testing. Correct issues with SQL Server performance with a more robust maintenance plan, process cleanup, and SSIS package automation. Install and configure a more up to date SQL environment monitoring tools like Idera to provide look ahead trend forecasting in order to manage current and future resource usage. Provide 24/7 support for the SQL and the windows environment. Install and configure SSRS for the monitoring tools to provide reports on the monthly state of the environment for future growth trends.
• Work with storage management team on the migration to an EMC SAN storage design. Manage the offshore support team.

Confidential

Sr. SQL DATABASE ADMINISTRATOR

Responsibilities:

• Since coming onboard at Confidential I’ve had the opportunity to upgrade sever sql instances moving them from sql 2008 to sql 2014, with plans to migrate the entire sql environment to 2016 by the forth qtr of 2017. I also took over the vetting of all sql server changes by reviewing each change and sitting with
• The CAB change board.I’ve built 3 new Always-on clusters as part of the new DR initiative between Raleigh and Dallas to provide geographical failover in the event of an outage.
• During the preparations for our Microsoft True-up I identify several sql instances that were underutilized and consolidate several of the instances, and in other cases sun-set the application altogether by doing so we could remove over a million dollars from our SQL Server licensing cost. Worked with Development team on Azure Project to deploy certain databases to the cloud for redundant access across the country pertaining to station location.

Confidential

SQL DBA

Responsibilities:

• Updated several processes that were causing blocking of certain instances that were bringing down some of the websites. Working with the infrastructure team on new installs and putting in place new standards to bring all sql instances up to the same level and
• Phase out several older instances. Presented a plan to bring more advanced monitoring tools into the environment to put the team in a more proactive mode. Work with the development team during the transition of some of the legacy systems and data imports into a new platform
• Called Aptify, so assisting with the data mapping and database build outs. Providing off shift support on a weekly rotation with other DBA.

Confidential

SQL DBA

Responsibilities:

• I’ve updated the monitoring tools to allow better tracking of system relevant problems like CPU and Memory usage, job failures, and storage issues on the SQL server instances by working with the developers who maintains their environment monitoring software called IT-Watch. Worked with the Jr. DBA on getting all the servers patched to the latest Service Pack level over the 3 maintenance windows.
• Brought online 3 SQL Server 2014 instances one each for Dev, QA, and Prod. Brought online 2 2012 SQL SERVERS Dev and QA that are currently undergoing migration testing for an In-house application being moved from SQL Server 2008 R2, and also relocated to a remote DR facility. Provide 24/7 support of SQL server environment.
• Assisting with a Microsoft Azure testing and build out project, which I’m currently evaluating databases to be moved into the Azure environment based on transaction load, DR requirement, and scale up cost. Also working with SSIS packages to bring in data from customer system to be inserted in customer maintained databases, using SSRS to build reports based on scripts to gather system stats, and support some smaller SSAS built cubes that take in stats on customer data and usage.

Confidential

SQL DBA

Responsibilities:

• I helped grow their 20 server sql environment to its current size 36 plus SQL server environment that supports the internal and external Stations that fall under the Tribune umbrella.
• Made significant changes in the backup mythology to shrink the recovery window in the event of an outage or dev and QA rebuild. Performance tuned a number of their highly critical servers which allowed those project to get back on track and go into full production usage by January 2015.
• Enhance the present Monitoring process so we’re more proactive when issues arise, this included early warning via not only E-mail but also text messaging individual support staff. Provide 24/7 support of all sql related events.

Confidential

SQL DBA

Responsibilities:

• Administer the 38 server SQL environment that contains a mixture of servers 2005 through 2012 that perform a high transaction batch e-mail process for our outfacing customer base. Our current work horse is a 3 terabyte database that contains customer product catalog information along with their customer mailing and e-mail address and information.
• I brought in a more robust monitoring tool from Idera that will allow the company to get ahead of issues before they impact the customer, this software will only monitor resource usage such as san storage, cpu, memory usage and database growth. It will also allow us to track trends to stay ahead of environment issues that will impact customer processing.
• I led the project to move some primary databases on standalone physical boxes to the virtual VMware environment via new SQL 2008r2 server build outs, and now developing a plan to migrate them to a new SQL 2012 environment by mid-year.
• I Developed a Patch project to bring all servers up to the latest patch level for SQL server 2008 R2 for the current production environment, and 2012 for the development environment. I'm currently working with the development team on a project to reduce the size of what is currently our largest database and reduce it into smaller node sql installs segregating the data based on customer grouping.
• Along with this design as a traffic manager I designed a 3 server cluster configuration for the traffic manager from the development team that routes what nodes customer transactions are to take place. As a precaution to a possible outrage of the global routing system, I installed Always-on availability with an availability group, with a double failover configuration of 2 backup servers.
• Although I’m part of the operations team, a great deal of my time is spent working with the development teams in code review test methodology migration from dev to QA to Production. As a requirement of support of both dev teams I regularly attend their morning meeting and some sprint meeting dependent on the project at hand.

Confidential

Sr. SQL DBA

Responsibilities:

• Administer an 82 SQL server database environment that includes a mix of legacy SQL 2000 server, SQL 2005 servers and SQL 2008 R2 servers. Spec out a more robust monitoring tool set to transform the SQL environment from reactive to proactive. Provide on call support to infrastructure team concerning SQL issues as they arise.
• Work with vendors on current legacy system that are out of spec for migration to newer supported platforms and virtual environments, and all future build for projects requiring SQL server as a data repository. Provide secondary support for the Oracle 11g on windows 2008 for the Hospital’s Maxsys application, and primary support to servers that are using McKesson products and applications.
• Build out a new reporting server to consolidate the current SSIS packages that generate reports based on certain applications, patient room, patient status, and patient billing. Install and configure SSRS and build SQL queries that gather certain server performance matrixes for the management to use during weekly environment evaluation.

Confidential

SQL DBA

Responsibilities:

• Manage the redesign of the new SQL server cluster environment to eliminate the current critical fail over point.
• Update DR documentation, schedule and perform in-house and DR site testing. Correct issues with SQL Server performance with a more robust maintenance plan, process cleanup, and SSIS package automation.
• Install and configure more up to date SQL environment monitoring tools, and look ahead trend forecasting. Provide 24/7 support for the SQL and the windows environment. Install and configure SSRS for the monitoring tools to provide reports on the monthly state of the environment for future growth trends.
• Work with storage management team on the migration to a new Net-App SAN storage design and migration path.

Confidential

SQL DBA

Responsibilities:

• Migration of current SQL 2000 Data warehouse to new SQL 2008 R2 cluster. Assist and update current security and apply new standards for the SQL server environments.
• Migrate all current production DTS packages to SSIS in the new SQL 2008 R2 environment.. Setup and configured SSRS in SQL 2008 R2 for migration of reports to the newer reporting servers for development, QA, and Production Environments.

Confidential

SQL DBA

Responsibilities:

• Administrate and support the current SQL 2005/2008 6 Terabyte environment of 150 servers, which includes server patching, performance monitoring and performance tuning, and backup schedule enhancements.
• Assist and update current security and apply new standards for the SQL server environments. Setup and manage SQL servers and application to remote manufacturing plants.
• Setup and configured SSRS in both SQL 2005, and SQL 2008 for migration of reports to updated reporting servers for development, QA, and Production Environments. Install and configure Quest spotlight monitoring tools for SQL environment.

Confidential

SQL DBA

Responsibilities:

• I created reports using SQL SERVER 2005 SSRS in both the QA and production environmentsFor their cosmetic manufacturing process to track raw material purchases, amount of product generated, and units shipped monthly.

Confidential

SQL DBA

Responsibilities:

• Administrate and support the current SQL 2005/2008 one Terabyte environment of 20 servers, which includes server patching, performance monitoring and performance tuning, and backup schedule enhancements.
• Assist and update current security and apply new standards for the SQL server environments. Help Automate the current Business process applicable to SQL server, and bring stability to the environment.
• Migrated many of the current SQL Server 2000 legacy DTS packages to SQL Server 2008 SSIS packages.
• Setup and manage log shipping processes for critical systems and application to remote hot site in a DR role.
• Built several SQL server 2008 environments for migration testing to standard clustered and hyper-V configuration using re-tasked equipment.
• Setup and configured SSRS in both SQL 2005, and SQL 2008 for migration of reports to the newer reporting servers for development, QA, and Production Environments.
• Provided research on EMC and Equalogics SAN technology for QA refresh project.

Confidential

SQL DBA

Responsibilities:

• Administrate current SQL 2005 environment containing 10 servers, which included service patching, performance monitoring, performance tuning, and backup schedule enhancements.
• Design and update configurations and security standards for the SQL server environments. Automate Business process where applicable to SQL server.
• Design migration process to upgrade SQL Server 2000 databases to SQL Server 2005 databases. Migrated and upgraded of many SQL Server 2000 DTS packages to SQL Server 2005 SSIS packages.
• Begin SQL Server 2008 migration research for 2QTR 2009 migration, by setting 2 SQL 2008 environments on to test the migration tool. Work with development team on Moss and Project server enhancements and migration to version 2007. Created Disaster Recover procedure documentation.

Confidential

SQL DBA

Responsibilities:

• Assist in the server upgrades, and build outs to SQL 2000, and 2005 servers across the Client’s
• SQL server enterprise network, numbering over 300 systems. Carried out successful upgrade of SQL Server 2000 databases to SQL Server 2005 databases.
• Carried out migration and upgrade of many SQL Server 2000 DTS packages to SQL Server 2005 SSIS packages Implemented High-availability of production databases by installing, configuring and maintaining SQL Server 2005 Clustering on Windows 2003 Server, SQL Server 2000
• Clustering on Windows 2000 Advanced Server and SQL Server 7.0 Clustering on Windows NT 4.0
• On average Handle between 10 and 15 Change Request per day, as well as Emergency system changes, and Off hours support review and install service packs for SQL 2000 and 2005 servers.
• Review stored procedure, trigger, and index code changes to ensure optimum system performance levels. Carried out disaster recovery of production databases in disaster situations resulting from disk failures, database corruptions, user errors and machine failures.

Confidential

SQL DBA

Responsibilities:

• Handle the plant upgrades to SQL server 2000, and LINX system which downloads plant information to several SQL server databases for plant processing, carried out successful upgrade of SQL Server 2000 databases to SQL Server 2005 databases, carried out successful upgrade of SQL Server
• 7.0 databases to SQL Server 2000 databases, carried out migration and upgrade of many SQL Server 2000 DTS packages to SQL Server 2005 SSIS packages.
• Implemented High-availability of production databases by installing, configuring and maintaining SQL Server 2005 Clustering on Windows 2003 Server, SQL Server 2000 Clustering on Windows 2000 Advanced Server and SQL Server 7.0 Clustering on Windows NT 4.0, monitor system performance, backups, and user activity of the 20 plus systems in production
• QA and Development SQL server systems. Provide remote Support for all plants SQL 2000 database servers in the phase I roll out which number 24 across the Country. On average Handle between 10 and 15 Change Request per day, as well
• Emergency system changes, and off hours support, assisted in the design, install, and management of the new share point cluster project Running SQL Server 2005, preparation for migration to SQL Server 2005
• Review and install service packs for SQL 2000 servers. Carried out disaster recovery of production databases in disaster situations resulting from disk failures, database corruptions, user errors and machine failures.

Confidential

Sr SQL DBA

Responsibilities:

• Sr. Database Administrator assisted with the relocation of the current production datacenter from South Carolina to Arlington Heights. Work with the systems engineer on building, testing and deployment or new
• Active/Active SQL 2000 cluster running under windows 2003.Updated the security design to improve better user activity tracking for the offices across the country.
• Set up nightly maintenance schedules for system backup, index rebuilds, log-shipping, and database consistency checking. Worked with systems engineer on designing a second layer backup strategy for DR, Developed a replacement for log-shipping process.
• Streamline QA test database rebuilds to minimize development stoppage. Carried out successful upgrade of SQL Server 2000 databases to SQL Server 2005 databases Carried out successful upgrade of SQL Server 7.0 databases to SQL Server 2000 databases.
• Carried out migration and upgrade of many SQL Server 2000 DTS packages to SQL Server 2005 SSIS packages.Implemented High-availability of production databases by installing, configuring and maintaining SQL Server 2005 Clustering on Windows 2003 Server, SQL Server 2000 Clustering on Windows 2000 Advanced Server and SQL Server 7.0 Clustering on Windows NT 4.0
• Carried out disaster recovery of production databases in disaster situations resulting from disk failures, database corruptions, user errors and machine failures.

Confidential

SQL/Oracle DBA

Responsibilities:

• Normalization of database tables, participate in the building and maintenance of production and development database tables using Erwin data-modeler software. Created PL/SQL scripts to assist in building and maintaining MS/SQL 2000 database Environment.
• Development and Testing of new stored procedures, chart stored procedure system cost impact, manage database table creations and updates to existing tables, and Monitor database Performance using MS, BMC, and Embarcadero software packages.
• Configured Production log shipping for recovery purposes and DTS packages to transfer user data for development testing.
• Co-Lead project to upgrade SQL 6.5 production server, which was running on NT, to SQL 2000 on a Windows 2000 server. Other projects includes moving the production environment on to a Dell Server cluster, with active/passive node fail over configuration, operating from a SAN storage system.
• Developed DBA productions and development procedures manual for daily DBA tasked, database instance moves, system activity monitoring, link server to access db connections, transaction log-shipping, daily maintenance packages, and db cleanup for the SQL 2000 servers.
• Built procedures for production database Migration to Oracle 9i. Install and test both Oracle 8i, and 9i database OS. Install Oracle OEM, and BMC database monitoring tools.
• Monitor Oracle and SQL 2000 database user security, and database performance using BMC X-Ray software. HP Systems Administration on HP7400, HP K420, HPD380, HP 5600 systems running HP-UX and 32 bit, manage UNIX performance tracking, patch levels management, kernel tuning. Assist in windows 2000 system administration; assist in building Business Resumption procedures.