Resume

Sign in

Sql Server Windows

Location:
Bloomsburg, Pennsylvania, 17815, United States
Salary:
110,000-130,000
Posted:
October 05, 2016

Contact this candidate

RAYMUNDO CARDENAS CASAS

Raymundo is a Microsoft Certified Technology Specialist having extensive experience primarily working as a Senior SQL DBA and Developer in large production environments. His expertise lies in the installation, configuration, implementation, developing, designing, analyzing, reporting and maintenance of SQL Server versions 2000, 2005, 2008 (32 and R2), 2012, 2014, 2016 and business Intelligence (SSIS and SSRS). He has excellent knowledge applying SQL Server best practices suggested by Microsoft, T-SQL and SQL scripts, creating and modifying stored procedures, triggers, tables, etc. Raymundo has troubleshooting knowledge monitoring SQL Server logs, system tables and windows logs. He has the skills to improve and apply solutions over the databases and instances using dashboard reports to make an I/O analysis, missing indexes and instance status. Raymundo has worked with multiple DB instances in local and virtual servers and large databases (more than 800GB) in Production and test environments. He has worked on maintaining and monitoring clustered servers. Raymundo has monitored SQL Server instances, databases and servers using SCOM and Quest tools for around 1000 servers (Non-production and production servers). He has created DTS, Jobs, and Sending Alerts using Database Mail. His expertise also lies in the migration of Data from Excel, Microsoft Access and MS SQL Server by using BCP, DTS and Business Intelligence utilities (SSIS and SSRS). Raymundo has created Backup and Recovery plans using SQL Scripts, Jobs and Maintenance Plans on Management Studio and using robot Comvault for SQL Server to backup on tapes. He has excellent experience updating and migrating SQL Server from 2000 to 2005, 2000 to 2008R2 and 2008 to 2016. He has developed templates and production reports using Reporting Services for web and desktop applications with SSRS, Excel, Crystal Reports v9 and v11 and Excel. He has also managed and monitored the space on the databases, data files and server devices. He has experience working with databases mounted in Virtual Servers - monitoring space and performance, adding space to the drives and checking any issues related to the database. Raymundo has excellent communication skills, leadership and ability to work in-group. Raymundo has experience working in the fields of Finance, Telecom, Insurance and Factory. Raymundo is fluent in English and Spanish languages.

CERTIFICATION:

(072-432)MCTS (Microsoft Certified Technology Specialist) SQL Server 2008

o2778A: Writing Queries Using Microsoft SQL Server 2008 Transact SQL

o6231A: Maintaining a Microsoft SQL Server 2008 Database

o6232A: Implementing a Microsoft SQL Server 2008 Database

(070-642)MCTS (Microsoft Certified Technology Specialist) Configuring, Managing and Maintaining Windows Server 2008

o6421A: Configuring and Troubleshooting a Windows Server 2008 Network Infrastructure

o6419A: Configuring, Managing and Maintaining Windows Server 2008 Servers

(070-640)MCTS (Microsoft Certified Technology Specialist) Windows Server 2008 Active Directory, Configuring

o6425B: Configuring and Troubleshooting Windows Server 2008 Active Directory Domain Services

o6426B: Configuring and Troubleshooting Identity and Access Solutions with Windows Server 2008 Active Directory

o6419A: Configuring, Managing and Maintaining Windows Server 2008 Servers

TECHNICAL SKILLS:

RDBMS: SQL Server 2000/2005/2008/2012/2014/2016, Sybase 11/12.5, Access, Oracle 9g/10g/11g

Development languages: T-SQL, VBA, C++, PowerShell

Database Tools: Enterprise Manager, Query Analyzer, Profiler, Tuning Advisor, Management Studio, SQL Server Profiler, Business Intelligent suite (SSRS and SSIS), Spotlight, DB Artisan, Attunity Replicate.

Reporting Tools: Business Intelligent suite (SSRS and SSIS), Excel, VBA, Access, Crystal Reports

Operating Systems: Windows 2012, 2008, 2003, 2000 Server, Windows XP, Vista, 7, 10, Linux, UNIX.

Backup Tools: CommVault, Quest Lite speed, SQL Native, Control –M, backup wizard of Microsoft.

Monitoring Tools: Spotlight, SCOM, Patrol, Control-M, and Quest.

Others: SharePoint, Microsoft Office, Open Office, Service Now, Lotus Notes, Remedy, VMWare.

PROFESSIONAL EXPERIENCE:

Sr. SQL Server DBA, Geisinger Health, PA 03/16-Present

Responsibilities:

Environment cover around 800 Databases in 200 Servers for Production and Non-Production environments with SQL Server instances from 2005 to 2016.

Installation and configuration of new SQL Server instances (2012, 2014 and 2016) based on best practices.

Work beyond regular hours based on business demands. Provided 24x7 on-call production supports.

Creation and managing of users and objects.

Assigning roles and privileges to different users as part of the security processes.

Create & Managing Database Structure, Storage Allocation.

Configuration and Maintenance of the Database Mail and native alerts

Responsible for installing, upgrading and configuring the SQL Server environment by creating multiple databases, storage structures and objects, database backup and recovery, monitoring and optimizing database performance.

●PowerShell scripting for maintenance purposes

●Maintenance, patching, configuration and failovers for 7 SQL Server Clusters

●Involved in the project of corralling the SSMS versions installed in the clients machines in order to migrate them from older versions to SSMS 2016

●Create and maintain backup strategies and capacity planning.

●Database migrations and upgrades to the latest versions of SQL Server

●Migration and maintenance of the SSIS packages

●Involved in performance monitoring and tuning of the database.

●Replication using Attunity and SQL replication clients

●Responsible for the backups, schedules,jobs and storage using Commvault

●Patching and upgrade of the SQL server instances

●T-SQL scripting for Store procedures, jobs or queries

●Troubleshooting for patching, performance and configuration issues

●Migration, restoration and management of Encrypted databases and certificates

●Trouble shooting and recovery of databases in suspect, recovering and emergency status

●Involved in creating tables, indexes and views and their maintenance.

●Monitoring the space and growth of the data and log files

●Tuning of queries and database processes in order to solve performance issues

●Trace the SQL databases in order to find a solution for issues or activities that affect the performance or behavior of the database.

●Involved in disaster recovery planning.

●Developed technical documentation for disaster recovery.

Environment: MS SQL Server 2005/2008/2008R2/2012,2014/2016, Business Intelligent suite (SSRS and SSIS), TSQL, Central Management Servers, PowerShell, SharePoint, VMware, Remote Desktop Connection, Terminal Services, Remedy, Spotlight, SQL Management Studio, Profiler, Tuning and Upgrade Advisor, Windows Server 2000/2003/2008/2012/XP/7/10, Microsoft office, Lync(Skype), CommVault, Attunity Replicate.

Sr. SQL Server DBA/Developer, American International Group (AIG), NJ 02/13-12/15

Responsibilities:

●Managed and administrate the SQL Database Servers of the Disaster Recovery Team

●Created and maintained backup strategies and capacity planning.

●Design, developing and implementation of new tables, store procedures, triggers, jobs, queries for the database (T-SQL)

●Updates, inserts and deletes on the data hosted in the database

●Analysis of the data in order to generate accurate queries and reports

●Data migration from multiple sources to multiple repositories (SSIS)

●Design, development, implementation, analysis and maintenance of the reports of the Disaster Recovery Team

●Development of the a new front-end in Access using VBA and C++

●ETL development using Business Intelligence (SSIS and SSRS) to create new processes to maintain the Data Bases and reports up to date

●Coordinate Latin America and support the Disaster Recovery exercises

●Gathering the application data and infrastructure in case of a Disaster Recovery and create the Application Recovery Plans

●Developing with VBA and VB studio to perform specific task and interactions between the data bases and the reports or Front Ends

Environment: MS SQL Server 2005/2008R2/2012, Access, Visual Studio 2008, Visual Studio 2013, Business Intelligent suite (SSRS and SSIS), TSQL, SharePoint VMware, Remote Desktop Connection, Terminal Services, VPN Checkpoint, FTP, MEGA, Service Now, SQL Management Studio, Profiler, Tuning and Upgrade Advisor, Windows Server 2000/2003/2008/XP/7, Microsoft office, Lync, AT&T connect.

Sr. SQL Server and Sybase DBA, Northern Trust, Chicago 04/11-10/12

Responsibilities:

Worked with approx. 1000 servers between production and non-production environments

Managed and administered SQL Server, Sybase and Oracle databases.

Administered SQL 2000, 2005 and 2008 Servers (32bits and R2), following ITIL process model for Northern Trust UNS DBA Support Team.

Created and maintained backup strategies and capacity planning.

Helped users to refresh (Restore) SQL Server, Sybase and Oracle Databases, Tables, Views, Stored Procedures, Packages, Body Packages, Schemas etc.

Monitored databases spaces, such as Table spaces, Devices, File systems etc.

Moved and migrated Data or Log Files to a different Server or Drives. Handled performance issues such as Blocking, Lock issues, Deadlocks.

Resolved database connection issues

Did the Security administration as orphan user. Also managed Roles, Granted or Revoked database permissions etc.

Monitored and administered SQL Server Cluster servers

Most of the databases were mounted in Virtual machines that we need to monitor and request and investigate space, performances and network issues into the instances. The virtual servers were mounted for Production and Non-Production environments

Package (SSIS) were created to migrate objects or table information between non-production environments to production and vice versa

Environment: MS SQL Server 2000/2008R2, Oracle 11g/10g/9i, Sybase SQL Server, TSQL, SSIS, SCOM, Control-M, VMware, Remote Desktop Connection, Terminal Services, VPN Checkpoint, FTP, Remedy, Patrol, Service Now, Quest, SQL Management Studio, Profiler, Tuning and Upgrade Advisor, AWE SQL, Windows Server 2000/2003/2008/XP, Unix, Linux, Lotus notes, VMWare.

SQL Server DBA/IT Analyst, Pertek Erler, Mexico 02/10-04/11

Responsibilities:

Managed ERP (modify, develop, repair) modules. Made reports for the manager. Analyzed information and developed queries.

Gave technical support to the users of the domain, manage the domain with Active Directory, created new counts for users, modify permissions

Managed the structure of files of the net, make backups of the servers

Provided support with remote desktop. Configured new connections

Developed new store procedures to apply into the databases for the new version of the ERP

Fixed and modified old SP’s, tables, jobs to work in SQL server 2008R2

Migrated information and objects by creating and configuring DTS and SSIS packages

Created, modified and updated data bases in access and then started to migrate to ASP.NET

Created packages and flows (SSIS) to update some tables

Managed DB in SQL Server 2000. Implementation of new server in Windows 2008, Active Directory. Migration of the ERP software (sytline 8.02).

Documenting maintenance of equipment (servers, desktops, routers, laptops, peripherals, etc.)

Developed new process and forms to the ERP. Migration of the DB’s to SQL server 2008R2. Developed new reports with Crystal Reports (IX, X and 2008)

Managed and monitored the LAN, switches, routers and Wi-Fi. Managed the DB of the McAfee antivirus Orchestor.

Monitored and administered cluster instances. Created, designed, administered databases in non-production and production environments.

Implemented a transactional replication environment with SQL Server 2008

Environment: SQL Server 2000, 2008, TSQL, SSIS, BCP, Backup wizard, Crystal Reports, RVC, Remote Desktop Connection, Terminal Services, SQL Management Studio, Profiler, Tuning and Upgrade Advisor, Syteline 8.02, Syteline 6.11, Access, Windows 2000/2003/2008/XP/Vista

SQL Server DBA, Grupo Hevi (Telecable), Mexico 02/09-02/10

Responsibilities:

Created and administered SQL Server 2005 databases with size around 900GB, that provided information to these apps and which contained curricular and personal data of all involved.

Created of Jobs, Stored Procedures and triggers to grant the security and data mining over databases.

Implemented queries improvements using the tuning advisor.

Analyzed I/O using traces with the SQL Profiler. Was also responsible for DBA functions like installation, configuration, maintenance, upgrading, migration, performance tuning, backup and restore of SQL Server 2005.

Developed reports for the directors of the company.

Environment: SQL Server 2005, Crystal Reports, RAMPS, Real VNC, Backup wizard, MS Access, Terminal Services, Windows 2003 Server, Windows XP.

IT Analyst, Pertek Erler, Mexico 10/08-02/09

Responsibilities:

Performed DBA functions like installation, configuration, maintenance, upgrade, migration, performance tuning, backup and restore of SQL Server 2000.

Handled all networks (Ethernet, LAN, MAN, AP, Switch, Routers, Hubs) Storage, Hardware Technical Support, Windows Servers and Handhelds.

Implemented web applications based on SQL Server database engine.

Created stored procedures to extract information and post in reports. Monitored SQL Server and Windows Server environment using Performance Monitor tool.

Implemented backup and recovery plans using job scheduler and Shell commands. Did user management by assigning appropriate permissions to the database users on SQL 2000.

Created security policies for the 4 instances. Handled Support tickets using their own helpdesk.

Tuned queries using tuning advisor. Give technical support to the users of the domain, manage the domain with active directory, create new counts for users, modify permissions

Developed new store procedures to apply into the databases for the new version of the ERP

Fixed and modified old SP’s, tables, jobs to work in SQL server 2000

Migrated information and objects using DTS and SSIS packages

Created packages and flows (SSIS) to update some tables and the forecast of the application to be easily the process of information load

Managed the structure of files of the net. Made backups of the servers

Gave support with remote desktop. Was responsible for configuring new connections.

Created, modified and updated data bases in Access and then started to migrate to ASP.NET.

Documented and maintained equipment (servers, desktops, routers, laptops, peripherals, etc.)

Created, designed and tuned databases.

Environment: SQL Server 2000, Crystal Reports, IIS, Visual Studio .NET, ASP, MS Access, Terminal Services, Windows 2000,2003 Server, Windows XP, Syteline.

EDUCATIONAL QUALIFICATION:

Bachelor’s Degree in Engineer in Cybernetic and Computational Systems Universidad La Salle Guadalajara. 2003-2008



Contact this candidate