SUMMARY:

• Database Design & Administration / Data Modeling / Data Management & Reporting
• Database Architect /Senior Production and SQL Server Database Administrator
• SQL Server 2005,2008,2012,2014,2016 Database Mirror, Replication, DTS/SSIS, SSRS, SSAS support and administration
• Oracle 10g,11g,12c, RAC 10g,11g,12c, RMAN support and administration on multiple platforms
• Mongodb
• Sybase ASE 12.x,15.x support and administration on Red Hat and Solaris
• WINDOWS system administration and UNIX (Solaris, Red Hat), including clustered systems
• Thorough understanding of, and long experience with: high availability; high - volume transaction processing; tight service level requirements; large database installations (in the TB range); pro-active monitoring; automation; remote administration of multiple databases, platforms, sites and organizations simultaneously
• Programming in: C/C++; Java, R, SQL; PL/SQL, T-SQL, Perl, Shell, DOS, CMD Shell Scripting
• Other utilities: SCOM, Toad, Erwin/Power Designer, VERITAS, DBArtisan, Spotlight, VMWare

CURRENT SKILLS EXPERIENCE:

• SQL Server Database Administration 15 years (DTS/SSIS, SSAS, SSRS)
• Oracle Database Administration 3 years (RAC 10g,11g,12c, RMAN)
• SQL Server Azure Cloud Services 2 years
• Sybase ASE Database Administration 2 years (ASE 12.x, 15.x)
• Windows System Administration 10 years
• T-SQL Programming 10 years (incl. Optimization, Profiling and Trace Analysis)
• PL/SQL Programming 2 years
• Shell Scripting (ksh, csh, DOS, CMD) 2 years
• ETL tools (DTS, SSIS) 5 years

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

SENIOR DATABASE ADMINISTATOR /TEAM LEAD

Responsibilities:

• Installed and configured SQL Server 2005, 2008, 2012, 2014, 2016 including SSIS, SSAS and SSRS
• Upgraded most SQL Server 2008 Servers to SQL Server 2014 and applied SPs
• Experience in maintaining high availability using always-on availability groups, failover clustering, database mirroring and log shipping for servers around the world in several domains.
• Participate in capacity planning, trend analysis, performance forecasting exercises and propose recommendations to meet the ongoing performance and scalability demands.
• Identify and isolate performance bottlenecks on SQL Server and Oracle databases
• Monitor and report on the availability of systems and services, load, connections, backup, space utilization, etc.
• Consolidate servers where necessary by combining databases or adding multiple instances on the same server to reduce cost and licensing fees
• Create and maintain technical documentation and implement database related policies
• Responsible for incident management, change management, and root cause analysis.
• Developed a series of automated solutions to perform proactive monitoring activities and maintain a high level of quality and integrity

Confidential, Houston, TX

SENIOR SQL DATABASE ADMINISTATOR

Responsibilities:

• Developed and maintained stored procedures, DTS packages, views, and user defined functions for a SAP application.
• Supported the application development teams in optimizing tables, indexes, stored procedures, triggers, and ad-hoc T-SQL.
• Diagnosed problems using tools such as SQL Profiler, Database Tuning Advisor (DTA), Perfmon (System Monitor) with vendors and developers to resolve performance issues.
• Monitored trends in disk space utilization, memory usage, and availability on key database servers.
• Created and managed database maintenance plans and design and implement backup and disaster recovery plans.

SENIOR SQL DATABASE ADMINISTATOR

Confidential

Responsibilities:

• Created and maintained SQL Server 2000, 2005, and 2008 databases.
• Managed and created reports to be used on the SQL Server 2005 Reporting Services (SSRS) and supported Microsoft Office SharePoint Server 2003 (MOSS 2003).
• Supported the application development teams in optimizing tables, indexes, stored procedures, triggers, and ad-hoc reports.
• Ensured data backup and recovery, maintenance, data integrity and space requirements for the database server environments.
• Managed database instances, monitor server performance, tuned the database server and applications, and performed backup and recovery.

SENIOR SQL DATABASE ADMINISTATOR

Confidential

Responsibilities:

• Created and maintained SQL Server 2000 and 2005 databases.
• Set up backup and recovery plans and monitor system performance.
• Installed and configured database software, upgrades and fixes, as required.
• Worked with the Oracle Disaster Recovery team to test switchover between the primary database and standby database.
• Coordinated all administrator activities with server administrators and user community.
• Developed backup plans based on client recovery time objective (RTO) and recovery point objective (RPO).
• Sets up and manages operators, alerts and e-mail notification for SQL Server jobs.

SENIOR SQL DATABASE ADMINISTATOR

Confidential

Responsibilities:

• Resolved database performance issues by reducing the database size by 45%, increased server memory by 62%, and created a job to monitor table blocks and deadlocks.
• Tuned indexes and reduced I/O bottlenecks.
• Added two disk drives to the server to spread the database disk load to more disk drives.

SENIOR SQL DATABASE ADMINISTATOR

Confidential

Responsibilities:

• Created, reviewed, approved, and monitor stored procedures and triggers used for user applications and back-end reporting tasks.
• Responsible for installing and maintaining SQL Server 2000 on a Clustered Microsoft Windows 2000 Advanced Server for a high-availability business application. Also installed and maintained SQL Server 2000 (64-bit) on a Clustered Microsoft Windows 2003 Server.
• Proactive in analyzing existing databases and recommendations on how to improve database performance and reliability.
• Monitored database growth, index fragmentation, and minimize I/O bottlenecks.
• Moved database objects from development, acceptance, and production environments.
• Set up backup and recovery plans, manage database replication, and monitor system performance.

Confidential, Houston, TX

SENIOR SQL DATABASE ADMINISTATOR

Responsibilities:

• Provided Database Administrator support for 400 SQL Server and Oracle databases.
• Served as security administrator that provides authorization to users, permissions for tables, views, and stored procedures.
• Created and assisted developing team in writing efficient T-SQL scripts and DTS (Data Transformation Services) packages.