PROFESSIONAL SUMMARY:

• SQL Server Database Administrator with 12+ years of experience and proven track record of designing, administering and supporting database systems, performance tuning optimization and capacity planning.
• 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 on windows active directory, network and database development.
• Expertise experience in handling level-one, mission critical applications. Java and .net applications running with ibm and apache or any other middle ware like tuxedo from PeopleSoft.
• Experience with on-call problem resolution and triage in SQL Server environments.
• Experience in working on teams such as Operating system Infrastructure, Storage, Networking configuring routers, hubs network cards for timming and TCP/IP devices, Development and QA.
• Certified Microsoft Certified Professional for sql server 2005 and 2008 and studying for pass more recent exams.

TECHNICAL EXPERIENCE:

Relational Databases: Access, SQL Server 2016, 2014, 2012, 2008 R2, 2008, 2005, 2000, 7, 6.5 and Oracle 12c, 11g, 9 or 8. DB2, Informix, Progress, Mysql, firebird, Data Warehousing concepts with Cognos and other sql tools. SSAS, SSIS, SSRS.

Operating System: Windows 20, 2000, NT (64 bit & 32 bit), Mac, Linux, Solaris, hp-ux, Novell, Irix, u-6000, aix, android, blackberry, Symbian, java and others.

Database Monitoring Tools: SCOM 2012/2010, Dell Spotlight on SQL Server, SQL diagnostics manager, Red gate SQL Monitor, SQL Doctor from Idera. Sentry One & Solarwinds Database Performance Analyzer.

Database Administration Tools: SQL Server Management Studio SSMS, Enterprise Manager EM, SQL Profiler, Veritas site to site, 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, EMC ExtremeIO. Implementing operational automation using scripts for disaster recovery or clone dev and QA or UAT from production and cleaninig confidential information for avoid issues with auditing and compliance.

Query/Reporting: SQL Query Analyzer, MS SQL Reporting Services and Crystal Reports. SAP PowerDesigner and Oracle Reports or E business tools, Data transformation services (dts) or SSIS (dtsx).

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

Programming Languages: T-SQL, PL-SQL, Java, visual basic, PowerBuilder and HTML, Microsoft Certified Technology Specialist for sql server 2005 and 2008.

Other skills: Providing technical and project management skills, as well as the willingness to engage in a hands-on way, to provide specific technical guidance and lead on database technologies.

PROFESSIONAL EXPERIENCE:

Confidential, Minneapolis, MN

Sr. SQL DBA Architect

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/20 bit and 32 bit) on traditional clusters and standalone servers, builded considering capacity planning and PTO.
• Installed, configured and maintained high available solutions such Clustering, Replication, and Log Shipping.
• Implementing as an expert database best practices.
• Physical and logical database design using Erwin.
• 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, veritas site to site between east and west datacenter and SAN replication.
• 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, data changes and menu changes through Software Development Life Cycle.
• 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. Sending Data to Hadoop for Bigdata analysis and POC.
• Developed Stored Procedures, Triggers using Transact-SQL and Remote query, checking java apps.
• 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, 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.
• Installing Windows Server OS / applications like ERPs and configuring networking and/or Active directory domain rights for grant proper permissions for new sql server instances or adding more networks or resources to existing sql server clusters and networks for backups using Symantec netbackup and other tools for SAN replication.

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 AnalyzerPerformance Monitor, Backup/ Recovery, Analysis Service, Database Transformation Services (DTS), SQL Server Reporting Services(SSRS). Microsoft Azure Cloud, powershell. Veritas S2S.

Confidential, Troy, MI

Sr. SQL DBA Architect

Responsibilities:

• Arquitecture planning and 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) setting best practices and depending of usage consider capacity planning and performance tuning and optimize depending of workload.
• Physical and logical database design using Erwin.
• Implementing as an expert database best practices.
• 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. Veritas site to site replication.
• 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.
• Worked on windows OS and network reconfiguration before, during and after moving to another or new datacenters and changing to another Active Directory Domain also reassigning permissions to new service accounts on Organizational Units or AD objects

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, EMC ExtremeIO, powershell. Veritas S2S.

Confidential, Atlanta, GA

SQL Server DBA

Responsibilities:

• Installation, PTO 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 and help on capacity planning.
• Arquitecture planning and Installing SQL Server products; managed patching and compliance issues.
• Physical and logical database design using Erwin.
• Implementing as an expert database best practices.
• 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 and log shipping or Veritas site to site.
• 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.
• Support on windows OS and network reconfiguration before, during and after moving to another or new datacenters and changing to another Active Directory Domain and reassigning permissions to new service accounts.

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, powershell.

Confidential, Oklahoma City, OK

Senior Database Architect

Responsibilities:

• PAFE offering service from gold partner assigned at Citi, 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 for improve Performance Database Ware House workload several times.
• Handling user requested issues through Remedy.
• Implementing as an expert database best practices.
• Arquitecture planning and 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)
• Arquitecture planning and 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, Windows 2012, VMWare,SCOM, SolarWinds DPA, Nagios, PeopleSoft, SAP, Microsoft Dynamics GP, EMC ExtremeIO. DB2, Informix, Oracle and other datasources for database loads to DWH, powershell.

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 fixes solution to several issues that come up from production
• Physical and logical database design using Erwin.
• Implementing as an expert database best practices.
• 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
• Arquitecture planning and 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 2014 and previous versions
• Installed SQL Server 2014 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 .

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 2010, Quest Little speed Windows 2003, 2008, 2012 server, hp ITIL tools, Dell Spotlight for SQL and Oracle.

Confidential

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.
• Implementing as an expert database best practices.
• Arquitecture planning also 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