SUMMARY:

• SQL Server Database Administrator with 12+ years of experience and proven track record of designing, administering and supporting database systems.
• Overall 12+ years of experience with most of it in SQL Server 2016, 2014, 2012, 2008 R2, 2008, 2005, 2000, 7, 6.5 and Windows 2016, 2012, 2008 R2, 2008, 2003 R2, 2008, 2000, NT 4.0.
• Experienced with creating IT solutions for a large inventory of SQL Servers using technologies such as high availability clusters, Always - On, Mirroring, Log-Shipping and Replication or any third-party software or hardware based like Veritas S2S, Vision Solutions or VMWare or SAN replication.
• Expertise experience in installation and configuration of SQL 2016, 2014, 2012, 2008 R2, 2008, 2005, 2000, 7, 6.5 SQL Server database services.
• Expertise Experience in provisioning and configuring Servers and Databases in Microsoft Azure Platform as a Service (PaaS) and Microsoft Azure Infrastructure as a Service (IaaS).
• Expertise experience in database Performance tuning, query optimization using DMV’s and DMF’s. Experience with configuring and analyzing extended Events & PSS diag, SQLRAP, sqlnexus, cleartrace, sql doctor, sql diagnostic manager, spotlight on sql server, foglight.
• Experience in installation, configuration and administration of MS Analysis Services.
• Expertise Experience in building complex SSIS and DTS packages using Business Intelligence Development Studio.
• Experience in implementation of encryption strategies such as Transparent Data Encryption (TDE) or from third party tools like vormetric.
• Solid IT infrastructure foundation and skilled in automation, scripting, security and database development.
• Expertise experience in handling level-one, mission critical applications.
• Experience with on-call problem resolution and triage in SQL Server environments.
• Experience in working with teams such as Infrastructure, Storage, Networking, Development and QA.
• Certified Microsoft Certified Professional for sql server 2005 and 2008 and studying for pass more recent exams.

TECHNICAL SKILLS:

Relational Databases: Access, SQL Server 2016, 2014, 2012, 2008 R2, 2008, 2005, 2000, 7, 6.5 and Oracle 12c, 11g, 9 or 8.

Operating System: Windows 2012, 2008 2005, 2000, NT (64 bit & 32 bit)

Database Monitoring Tools: SCOM 2012/2010, Dell Spotlight on SQL Server, SQL diagnostics manager, Red gate SQL Monitor and Idera.

Database Administration Tools: SQL Server Management Studio SSMS, Enterprise Manager EM, SQL Profiler, Control - M, Microsoft Visual Studio, Business Intelligence Development Studio, SQL Server Data Tools, Data and Quality Services, SQL Server Integration Services, Master Data Services, Data Quality Tools. Toad for SQL, Oracle, Mysql and DB2. Mysqladmin. Xampp.

SQL Server Backup, Integrity Check, and Index and Statistics Maintenance Tools: NetBackup, Dell SQL Lite Speed, Control-M, Ola Hallengren.

Query/Reporting: SQL Query Analyzer, MS SQL Reporting Services and Crystal Reports. SAP PowerDesigner and Oracle Reports or E business tools.

Data Model Tool: ERWIN, CA ModelMart, DataArchitect, Toad Data Modeler.

Programming Languages: T-SQL, PL-SQL, Java, visual basic, PowerBuilder and HTML

PROFESSIONAL EXPERIENCE:

Confidential, Minneapolis, MN

Sr. Senior SQL Server DBA

Responsibilities:

• Leaded a DBA team of around 30 members located in Tempe, Arizona and different locations in Europe, Middle East and Asia.
• Installed, configured and administered SQL Server 2014/2012/2005/2000 (64 bit and 32 bit) on traditional clusters and standalone servers.
• Installed, configured and maintained high available solutions such Clustering, Replication, and Log Shipping.
• Installed, configured, and administered SQL Server Reporting Services (SSRS) for different purposes like DBA Reports, and user reports using SSRS.
• Supported several active/passive cluster installations in virtual environment and on VMWare.
• Developed stored procedures and scripts for automation of several daily maintenance tasks, monitor critical database alerts, monitor any blocking process for more than 3 minutes.
• Supported lease replacements of SQL Servers which included identifying servers coming out of lease, providing specifications for provisioning of new servers and migrating databases to new servers.
• Supported monthly SQL server patch process which included patching SQL servers with latest service pack and time sensitive security patches. Provided user support during post patch validation of the databases and applications.
• Supported upgrade process from SQL 2000/2005/2008 to SQL 2008 R 2/2012/2014/2016 depending on compatibility of migrated applications.
• Analyzed business requirements and converted them into functional specifications.
• Set up alerts, operators, Database Mail, SQL Mail, SQL Agent Mail, and notifications.
• Managed Database users and security.
• Designed processes to control migrations of programs, database and application changes, reference data changes and menu changes through SDLC.
• Monitored SQL servers for errors and performance degradation.
• Resolved database performance issues, replication, and other distributed data issues.
• Assisted Database Developers in optimizing SQL queries used in Stored Procedures and Triggers.
• Responded quickly and effectively in triaging issues in production & development environment.
• Participated in annual disaster recovery exercise for level one applications which included failing over databases from primary site to disaster recovery site.
• Move, transform, and load heterogeneous and homogeneous into SQL Server databases, as well as export SQL Server data to text file and other database systems or generate ftp transfers for SAP reports for manufacturing and financial areas.
• Developed Stored Procedures, Triggers using Transact-SQL and Remote query.
• Implemented Batch programs using command prompt utilities like SQLcmd, DTSrun, etc.
• Worked extensively on configuring third party monitoring tools such as hp Site scope and VRops.
• Implemented backup solutions using third party tools such as Net Backup, SQL Lite Speed.
• Testing Microsoft Azure for use ScaleArc virtual machine for migrate databases from sql 2000 and 2005 to 2008, 2012 or 2014 with minimal outage.
• Migrating SAP and Oracle Databases to virtual machines running sql server in Microsoft Azure.
• Configuring virtual box and java virtual machines for test applications that will be migrated to the Microsoft Cloud taking advantage of contract for move everything to the cloud.

Environment: SQL Server 2014/2012/2005/2000, Windows 2012/2008/2003, SQL Server Integration Services (SSIS), SQL Profiler, Data Model, SQL Trace, Transact SQL (T-SQL), SQL Query Analyzer,Performance Monitor, Backup/ Recovery, Analysis Service, Database Transformation Services (DTS), SQL Server Reporting Services(SSRS).

Confidential, Troy, MI

Sr. SQL Server DBA

Responsibilities:

• Installation, configuration and administration of Microsoft Windows Servers running SQL Server.
• Installation, configuration and administration of SQL Server 2012, 2008 R2, 2008, 2005, 2000 (Engine, OLAP, Integration Services and reporting services)
• Performed capacity planning on existing and on new systems in development and production environments.
• Acted as change control to implement any changes to production environment for peoplesoft, SAP and in house apps. Schema/data/configuration changes were tested in lower environments.
• Developed a process to restore production database to lower environments after data sanitization process.
• Developed a daily DBA checklist to monitor the health of the SQL servers in production to maintain 99.9 % uptime.
• Upgrade experience from SQL 7.0 or 2000 to SQL 2005, 2008/2012, 2014
• Deployed and maintained DTS packages to move data from heterogeneous sources to SQL Server as well as perform several data transformation.
• Analysis of Business requirements and converting them into functional specifications after extensive reviewing.
• Monitored locking, blocking and resource utilization by package caching, buffer cache hit ratio etc.
• Reviewed and proposed strategic changes to production systems. Implemented effective tape backup strategy.
• Validate and test new Service Pack levels and new SQL Server Versions before recommended to customers.
• Worked with the development staff to troubleshoot the query performance.
• Reviewing user and groups that no longer have access to databases or instances on different environments.
• As Solution delivery DBA I was supporting several customers like DHL, National Grid, One America, McKesson, PHS, Presbyterian Hospitals and others from all over the world for new SQL Server projects that use SAP, Peoplesoft or another ERPs and CRM modules, last project supporting Sql server databases for SAT (TAX Administration from Mexico) datacenter.

Environment: SQL Server 2014, 2012, 2008 R2, 2008, 2005, 2000/7.0, Window 2012, 2008, 2003, 2000/NT, DTS, Batch Scripting VMWare, Little Speed, Citrix, Microsoft Dynamics GP.

SQL Server DBA

Responsibilities:

• Installation and configuration of SQL Server 2012, 2008 R2, 2008, 2005, 2000 on Windows Server 2012, 2008 R2, 2008, 2003, 2000.
• Providing design, development, and testing support to assigned application teams deploying changes on SAP and sharepoint applications.
• Installing SQL Server products; managed patching and compliance issues.
• Maintaining Transactional SQL Replication between source and target SQL Server databases.
• Involved in migration of SQL Databases using Migration Utility.
• Setting up linked servers between SQL and Oracle, DB2, SAP or any other data sources.
• Configured SQL Database Mail where in the SQL Server will send notification for jobs or alerts through a email group account on failure of a job on production and email on non-production environments.
• Worked on data modeling projects from starting to finishing, generated scripts for objects, Developed Relationship, and created E-R Diagram using ERWIN.
• Export & Import data from Flat file, CSV file to/from SQL Server databases using DTS, and BCP
• Scheduling of operation and outages for network change or migration to another datacenter.
• Monitored Database Backup and other jobs in the maintenance plan Restoration and Point-in Time Recovery.
• Creating, modifying and managing tables, Index, Constraints, Views, Stored Procedures, and Triggers.
• Created and maintained documentation such as infrastructure diagrams, implementation guides, and incident reports.
• Optimized long running Stored Procedures for effective data retrieval.
• Troubleshooting and resolving problems with production SQL server databases.
• Monitored database status including CPU, memory, I/O, space, and dead lock using SQL Server Utilities.
• Created alerts, notifications, and emails for system errors, insufficient resources, fatal database errors, hardware errors, and security breach.
• Designing a Microsoft Windows 2000 Directory Services Infrastructure.
• Support for end users connected to servers in various departments regarding connection and data access issues.

Environment: SQL Server 2014, 2012, 2008 R2, 2008, 2005, 2000/7.0, Windows 2012, 2008, 2003, 2000; SCOM, Veritas Site to Site for replication, Visio, SAP financials, HR or serveral modules and HP software for ITIL and backup, Microsoft Dynamics GP

Confidential, Oklahoma City, OK

Senior Database Architect

Responsibilities:

• PAFE offering service from gold partner assigned at Confidential, Banamex-CF, INEGI, Laureate International Universities: UVM-UNITEC, CFE, Sonda, SCJN, ISSSTE, Mondel z international (helping optimizing datamarts and sql server for DWH and reporting monthly) and SAT as Database administrator and Architect for DWH On Triara datacenter for a VMWare virtual machine migrating from sql 2012 to 2014 for improve Performance Database Ware House workload several times.
• Handling user requested issues through Remedy.
• Responsible for change managements, validated the documentation for MS SQL Server and implementation plans.
• Scheduled maintenance Jobs and Alerts using SQL Server Agent by creating database maintenance plans.
• Creating the column store indexes on right columns of the tables; trace out for any tables that require for any indexes and determine the type of index on it.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
• Tested and successfully implemented Log Shipping or Replication technique for production databases as a High Availability solution.
• Created SSIS Packages for import data from databases in SAP, db2, Informix, Oracle or Plain Text files for consolidate DWH for with initial load and then schedule deltas for update information.
• Created database objects like tables, views, indexes, stored-procedures, triggers, cursors
• Successfully Configured Snapshot, Transactional and Transactional with updatable subscription in Replication.
• Administering the MS SQL Server by creating user logins with appropriate roles, dropping the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
• Perform Database Consistency checks by DBCC commands and Dynamic Management Views at regular intervals to check for fragmentation and torn pages in tables of databases and to improve the overall performance of the database
• Created Maintenance Plans for production servers (Full, Differential and Transactional Backups)
• Installation of MS SQL 2014 servers on production, Test and Development boxes.
• Handling user requested using service now ticketing system.
• Handling user requested issues through Remedy.
• Responsible for change managements, validated the documentation for MS SQL Server and implementation plans.
• Scheduled maintenance Jobs and Alerts using SQL Server Agent by creating database maintenance plans.
• Creating some column store indexes on right columns of the tables; trace out for any tables that require for any indexes and determine the type of index on it for DTW and OLTP database engines.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
• Tested and successfully implemented Log Shipping or Replication technique for production databases as a High Availability solution.
• Created database objects like tables, views, indexes, stored-procedures, triggers, cursors
• Administering the MS SQL Server by creating user logins with appropriate roles, dropping no longer needed logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
• Perform Database Consistency checks by DBCC commands and Dynamic Management Views at regular intervals to check for fragmentation and torn pages in tables of databases and to improve the overall performance of the database
• Created Maintenance Plans for production servers (Full, Differential and Transactional Backups)
• Create policies on Imperva secure for block sensitive information and implementing database security.
• Implementation of best practices recommended by Microsoft and setting database maintenance for instances mainly on SQL Server instances migrating engines from Oracle and DB2 and updating from SQL 2000, 2005 to newest versions like 2008 R2, 201X, optimizing database infrastructure following best practices for have a health environment on data centers using VmWare as hyper-visor and configure for compliance and with least privilege principle consolidating databases on a big clusters for reduce licensing costs for enterprise and only pay for 3 cores instead of bill for 300 to Microsoft.

Environment: SQL Server 2012-2014, Windows 2012, VMWare,SCOM, SolarWinds DPA, Nagios, PeopleSoft, SAP, Microsoft Dynamics GP.

Confidential, Chicago, IL

Senior Database Administrator

Responsibilities:

• Involved on the installation for the distinct platforms SQL Server versions.
• Involved in setting up the different environments line installation of SQL Server
• Provided hot fixe solution to several issues that come up from production
• Integrate the design for MS-SQL server databases for the project.
• Involved in Data Migration from Development to UAT using Quest tools.
• Integrate the distinct High Availability solution (Mirror, Cluster, Replication and Log shipping)
• Performed daily tasks including backup and restore by using SQL Server 2008 and 2012 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Involved in creating logical and physical data models using visio for new requirements after discussion with technical team and application users as per agile methodology
• Responsible for optimizing all indexes, SQL queries, stored procedures to improve the quality of software
• Created SSIS packages to pull data from OLTP to Reporting servers
• Used performance monitor/SQL profiler to solve dead locks/long running queries after debugging.
• Done Backup and restore of development servers and production servers.
• Documented all the new procedures, troubleshooting issues and solutions, Enhancement and changes in Daily and monthly running processes, and maintain the database for future reference
• SQL Server Database Maintenance, design a backup strategy to fit available budget, Cluster State Management and other Disk Integrity and Data preservation methods.
• Performed Data Flow Diagrams, Entity Relationship Diagrams, Data Diagrams, Table Structures.
• Enhanced the old logical and physical database design to fit new business requirement, and implemented new design into SQL Server 20XX
• Installed SQL Server 20XX and Management tools using SQL Server Setup Program.
• Installed SQL and manage all databases running inside the windows server or cluster from 2 to 5 nodes.
• Wrote T-Sql queries, Store Procedures and used them to build packages.
• Wrote scripts to monitor the databases.
• Involved designing and developing packages and Data Migrations.
• Monitor the databases with the distinct tool (Dell spotlight and hp OpenView tools)
• Responsible for optimizing all indexes, SQL queries, stored procedures to improve the quality of software.
• Designed, reviewed and created primary objects (views, indexes, etc.) based on logical design models, user requirements and physical constraints.
• Documented all the new procedures, troubleshooting issues and solutions, Enhancement and changes in Daily and monthly running processes, and maintain the database for future reference.

Environment: Windows 2000, 2003, 2008, 2012; SQL2000, 2005, 2008, 2012, 2014; Service Now for ticketing following ITIL, Migrating PeopleSoft to SAP, SSIS 2005,2008, 2012, SSRS 2005,2008, 2012, SSAS 2005,2008, 2012, MSRA Visual Studio, .NET 20XX, Quest Little speed Windows 20XX server, hp ITIL tools, Dell Spotlight for SQL and Oracle.

Senior Database Administrator

Responsibilities:

• Done Database Installation, Configuration, Maintenance, Monitoring, Backup and Disaster Recovery procedure and Replication.
• Deployed reports in MS SQL Server 2000, 2005, 2008, 2012.
• Designed, reviewed, and created primary objects (views, indexes, etc.) based on logical design models, user requirements and physical constraints.
• Monitor Databases and app servers
• Worked on developing DB admin related scripts, setting up administrator jobs like data purge, index rebuild, database consistency checks, and database data file shrink jobs.
• Worked on Query Optimization, helping developers.
• Performed backup strategy for all the databases.
• Worked on performance analysis and capacity tuning.
• Performed Disaster Recovery through Log shipping, replication and Failover Cluster.

Environment: SQL Server 2000, 2005, 2008, 2012; SAP, peoplesoft, MSDE, Crystal Reports, Visual Studio .Net, DB2, Oracle, VB Script, VBA, AS400

PAFE Partner Field Engineer

Responsibilities:

• Done Database Installation, Configuration, Maintenance, Monitoring, Backup and Disaster Recovery procedure and Replication.
• Deployed reports in MS SQL Server 20XX.
• Designed, reviewed, and created primary objects (views, indexes, etc.) based on logical design models, user requirements and physical constraints.
• Monitor Databases and app servers
• Worked on developing DB admin related scripts, setting up administrator jobs like data purge, index rebuild, database consistency checks, and database data file shrink jobs.
• Worked on Query Optimization, helping developers.
• Performed backup strategy for all the databases.
• Worked on performance analysis and capacity tuning.
• Performed Disaster Recovery through Log shipping, replication and Failover Cluster.

Environment: SQL Server 20XX, MSDE, Crystal Reports, Visual Studio .Net, DB2, Oracle, VB Script, VBA, AS400, Microsoft Dynamics GP

SQL Server Database Administrator I

Responsibilities:

• Installed and Implemented SQL Server 2008.
• Installed and monitored Replication.
• Created and design databases for any requirement
• Implement systems on sql according the client request.
• Used CommVault utility for backup and restore the production databases.
• Migrated databases from Test to Production environment for the development team to work on.
• Created various maintenance jobs, which included Data Migration, Index rebuilding, updating the statistics and Clearing the historical event logs, log file shrink jobs and other DBCC jobs.
• Frequently monitored the performance issues on the Production Servers using SolarWinds tools.
• Provided necessary documentation .
• Provided 24/7 supports for the Production and Replication environments to make sure the replication agents are running and all the replicated databases are in synch with production databases.

Environment: Oracle, Banner, MS SQL Server 20XX, SSRS 20XX, SSIS 20XX, BIDS, T-SQL, .NET, Visual studio 20XX, ASP.NET, DTS, Data Analyzer, java script, MS Access, Excel, SQL Profiler, Windows Server, VMWare, PowerFAIDS, PowerCampus, Confidential Mobile ERP, Microsoft Dynamics GP.

Confidential

SQL Server Database Administrator I

Responsibilities:

• Migrate sql server databases from old to newest versions.
• Involved in production support and attended new requirements as per the request of the client.
• Provided production support to videoconferencing, remote desktop and vpn access. Developed on-line problem tracking system in Windows Tools.
• Designed and developed online web customization for look and fell usability requirements.
• I have created, installed and maintenance various networks, installing needed software and hardware for the desired implementations
• Applied patches and fixes to windows and database environments to correct software issues that did not meet functional specifications.
• Involved in modification of pages and web and source code changes.
• Implemented a lot of products for the Windows environment for secure the whole system.

Environment: ERP, CRM, reporting tools and services, Component Interface and Visual basic Code, Compuware and Quest software for analysis of best practices and implement needed modifications., cgi, Perl, VB.Net and SQL Server 2005 and Oracle RAC, Hyperion.

Senior Database Analyst

Responsibilities:

• Migrate sql server databases from 6.5, 7, 2000 to newest versions.
• Involved in production support and attended new requirements as per the request of the client.
• Provided production support to videoconferencing, remote desktop and vpn access. Developed on-line problem tracking system in Windows Tools.
• Designed and developed online web customization for look and fell usability requirements.
• I have created, installed and maintenance various networks, installing needed software and hardware for the desired implementations
• Applied patches and fixes to windows and database environments in order to correct software issues that did not meet functional specifications.
• Involved in modification of pages and web and source code changes.
• Implemented a lot of products for the Windows environment for secure the whole system.

Environment: ERP Baan, CRM, reporting tools and services, SQL Server 200X and Oracle, Sql Sentry, Hyperback, redgate tools, BIDS for migrate dts to dtsx and also pragmatic works tools for increate productivity.

SQL Server DBA

Responsibilities:

• Migrate sql server databases and related applications from 2000 to 2008 R2.
• Involved in production support and attended new requirements as per the request of the client.
• Migrating databases and applications from sql 2000 to 2008 r2 version for integrate BofA and Merryl Lynch adapting code for access, visual basic 6, power builder as baml.com apps.
• Involved in source code and modification of webpages and source code changes.
• Implemented a lot of products for the Windows environment for secure the whole system.

Environment: Visual Basic, PowerBuilder, reporting tools and services, SQL Server 2000, 2005 and IBM MQ Series.

Confidential

SQL Server Remediator

Responsibilities:

• Migrate sql server databases and related applications from 2000 to 2008 R2.
• Involved in production support and attended new requirements as per the request of the client.
• Involved in source code and modification of webpages and source code changes.
• Implemented a lot of products for the Windows environment for secure the whole system.

Environment: Reporting tools and services, SQL Server 200X.Oracle, mysql, Sun, streetseller, mrecharge.

Confidential

Database Administrator

Responsibilities:

• Sql server database administrator implementing performance tuning in lab, Dev, stage and production environments.
• Application Performance Counters test with the Operations Intelligence Center in the case of some incident or root cause analysis for any production issue and fix or forward the issue to another team.
• Application Performance Counters test with the Operations Intelligence Center in the case of some incident or root cause analysis for any production issue and fix or forward the issue to another team.
• All work has a ticket for follow up per wing to wing (w2w) GE process till resolution.
• Implementation of best practices and sql server common standard routines for improve database and windows performance of shared services environment hosting more than 100 databases worldwide accessed.
• Administration of Rational ClearQuest and ClearCase for source code versions.
• Designed and developed green belt projects using CMMI and lean techniques for software configuration management for get a desired RUP and CMMI level for audits.
• Expertise using Windows and sql tools design, develop, test and implement fields, tables, views, stored procedures, defaults, indexes, primary and foreign key constraints and queries to satisfy end-users business requirements.

Environment: SQL server, Rational, Mercury and Oracle applications, Quest and windows tools for monitoring 24x7x365 lab, development, stage and production database systems. Managing db that use to store spotlight and Foglight for sql information.

Confidential

Database Administrator

Responsibilities:

• Sql server database administrator implementing performance tuning in lab, Dev, stage and production environments.
• Application Performance Counters test with the Operations Intelligence Center in the case of some incident or root cause analysis for any production issue and fix or forward the issue to another team.
• Application Performance Counters test with the Operations Intelligence Center in the case of some incident or root cause analysis for any production issue and fix or forward the issue to another team.
• All work has a ticket for follow up RUP process till resolution.
• Implementation of best practices and sql server common standard routines for improve database and windows performance of shared services environment hosting more than 3000 databases worldwide accessed.
• Administration of Rational ClearQuest and ClearCase for source code versions.
• Designed and developed green belt projects using CMMI and lean techniques for software configuration management for get a desired RUP and CMMI level for audits.
• Expertise using Windows and sql tools design, develop, test and implement fields, tables, views, stored procedures, defaults, indexes, primary and foreign key constraints and queries in order to satisfy end-users business requirements.

Environment: SQL server, Rational, Mercury and Oracle applications, Quest and windows tools for monitoring 24x7x365 lab, development, stage and production database systems, phpnuke storing information on mysql. Project server, sharepoint, Rational ClearQuest and Clearcase for SDLC SAP for HR, Banking, retail and financial experience.