SUMMARY:

To obtain a valuable position that will utilize my extensive knowledge in technology and database development and promote my innovative thinking.

TECHNICAL SKILLS:

Operating Systems: Windows 3.1, Windows 95, Windows 98 SE, Windows NT, Windows 2000, Windows XP, Windows Server 2003, Windows SBS 2003, Windows SBS 2008, Windows 7, Windows Server 2008, Ubuntu 10, Centos 5.4 and Linux Redhat.

Software: Microsoft ISA, MS Exchange 2000, Exchange 2003, Exchange 2007, IIS 6.0, Citrix Metaframe, Citrix XenApp, Citrix XenDesktop, VB 6.0, VB.NET, ASP.net, C and C++, C#, MS Office 2000, Office XP, Office 2003, Office 2007, MS Visio 2003, Visio 2007, Crystal 8.0, Crystal 9.0, Crystal XI, Millennium Payroll Software, Norton Antivirus Corporate Edition, Trend Micro Server Protect 5.58, Panda Endpoint Security, Confidential backupexec 8.5, Confidential Backup, Asigra DS - System 10.0

Databases: DB2, SQL Server 2000, SQL Sever 2005, SQL Server 2008, MS Access 2000, MS Access 2003 and MS Access 2007

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

Senior Database Adminitrator (DBA)

Responsibilities:

• Maintain a Production environment with over 150 MS SQL Servers ranging from SQL 2008 to SQL 2016.
• Develop security scheme(s) for the database environment; plan and test disaster recovery processes and procedures to meet business’s recovery point objective (RPO).
• Configure and utilize SQL Server monitoring tools such as SQL SentryOne and Quest’s Foglight and Performance Investigator (PI).
• Provides leadership during the development and enhancement of production applications including working with development, technical support and operations during the design, development and implementation phases.
• Work closely with middleware application administrators to identify the database resource requirements and to improve operational processes.
• Deploy database change scripts provided by in - house development team or third-party vendors
• Work with vendors in evaluating and implementing new technologies
• Train, mentor and develop Jr level DBAs, technical support staff and development staff
• Maintain and expand documentation of the company’s database environments.

Confidential, Fort Worth, TX

SQL Developer/DBA

Responsibilities:

• Maintained a SQL 2014 cluster database running on Windows 2012 R2 virtual cluster for Confidential ’s Epicor ERP environment.
• Maintained several SQL 2012 databases for ancillary systems (Manifest, HCM, etc.).
• Developed a data warehouse as part of Confidential data consolidation project.
• Developed reports for different departments using SSRS 2012/2014 and Epicor ERP (RDD).
• Part of the team that upgraded the Epicor ERP system from 9.0 to 10.1
• Designed and implemented Confidential ’s data recovery process as part of the company Disaster Recovery procedure using SQL clustering, SQL always-on availability Group and Azure SQL database

Confidential, Frisco, TX

SQL Developer

Responsibilities:

• Maintained SQL database for several clients in Oil and Gas industry as well as Health Care industry.
• Designed different ETL processes using SSIS packages to pull data from different vendor systems.
• Led the database team that developed a Master Data Management (MDM) initiative for a big Oil and Gas client using SQL 2014 MDS.
• Designed and Implemented a data mart used by Power BI for analytics and reporting purposes for a health care client.
• Created different stored procedures to pull data from a SharePoint online portal.

Confidential, Bedford, TX

Business Solution Provider

Responsibilities:

• Developed reports for different clients using SSRS 2008 and Crystal Report XI.
• Create ETL processes (SSIS packages) to extract data from different source and load them into different production databases.
• Designed and implemented several Disaster Recovery and Business Continuity Plans for different clients.
• Designed and Implemented maintenance processes for Confidential internal databases as well as client databases.
• Designed and implemented small OLAP environments for different client using SSAS 2008 (OLAP database and cubes).
• Developed small .NET applications to support business processes (internally and externally).
• Provided support for Citrix XenApp and XenDekstop infrastructure.
• Part of the team that develop a Dynamics AX infrastructure for a client (database and formulas)
• Provided support for Dynamics Anywhere application (Third party application)

Confidential, Fort Worth, TX

Database Administrator/Data Analyst

Responsibilities:

• Maintained and optimized a clustered SQL 2005 Server environment for Confidential Health Electronic Medical Record System (NEXTGEN).
• Designed and implemented a Disaster Recovery process for electronic medical records (EMR) databases.
• Created Stored Procedures and SSIS packages to extract data from a SIEMENS mainframe to several different SQL servers.
• Maintained and optimized several custom applications using VB.NET and SQL 2005 Server.
• Developped several reports for Confidential Health Business Unit using SSRS 2005 and Crystal Report XI
• Part of the team that designed and implemented a custom reporting portal for Confidential Health Business Unit.
• Designed and implemented a small OLAP environment using SSAS 2008.
• Responsible for audit procedures, change control, documentations, and security implementation for diverse database components.
• Produced database documentations, SOP’s and IT policies

Confidential, Dallas, TX

Systems/ Database Administrator

Responsibilities:

• Migrated a MS Windows NT environment to MS Windows Server 2003 with Active Directory for the Dallas Millennium office.
• Designed and maintained a MS Windows Server 2003 infrastructure with 25 servers and 40 workstations.
• Maintained and managed integrity, high availability, point in time recoverability, and security for all mission critical payroll databases built in SQL Server 2000 and MS Access.
• Designed, analyzed, optimized and maintained stored procedures, DTS Packages, relationships, views, scripts, queries, indexes, resources and all other components SQL Server 2000 and Access utilize.
• Responsible for system performance monitoring and software updates.
• Maintained network security policies, address server security issues and apply appropriate security patches and upgrades
• Responsible for audit procedures, change control, documentations, and security implementation for diverse network and database components.
• Member of the Millennium team responsible for making the Confidential SAS70 compliant in accordance with the Sarbanes Oxley Act.
• Maintain the branch’s network infrastructure, including but not limited to intra-building fiber optic cabling, intra-office Category 5 cabling (CAT 5 and CAT 5e), patch panels and telephone system cabling.
• Configure network equipments(LAN/WAN) including Cisco Routers, Dell Switches, Nortel Switches and Nokia Firewalls.
• Maintain custom applications utilizing ASP, VB, SQL server 2000, and HTML.
• Design and implement the Disaster recovery and Business Continuity Plans for our production environment.
• Produce system/network documentations, SOP’s and IT policies
• Maintain inventory of IT assets and track licensing compliance

Systems Analyst

Confidential

Responsibilities:

• Worked closely with business unit to design and develop appropriate application modifications and new programs to facilitate business functions and resolve business issues.
• Performed different network monitoring and tuning procedures using MS administrative tools (netmon, performance monitor, etc) and several other network tools.
• Performed several database performance tuning operations using SQL Enterprise Manager, and SQL Query Analyzer.
• Maintained and analyzed SQL Server 2000 and Access 97 database integrity using various database tools (Enterprise Manager, Query analyzer, etc).
• Designed and implemented complex financial statements and company reports using Crystal Report version 8.0 and 9.0.
• Responsible for system updates including (MS Windows updates, MS Office updates and SQL Server 2000 updates).
• Provided high level technical support to clients with payroll application issues or internal network issues.
• Developed and enhanced custom applications utilizing ASP, VB, SQL Server 2000, and HTML.
• Configured and maintained daily tape backups for production databases and network files using Confidential backup and Confidential Backup exec software to ensure restoration of critical data and sensitive files.

Confidential, Morgantown, WV

Lab Assistant

Responsibilities:

• Provided support to staff and students in computer hardware and software.
• Assisted with computer applications.
• Maintained small lab network as well as doing regular system testing and diagnostics.