SUMMARY

• Has over 14 years of IT systems and database administration, database design, development, and network analyst, and management, and application development experience, with extensive life - cycle systems and application software design, implementation, and management expertise.
• Successful record of delivering high-performance IT systems and database systems and solutions that help organizations achieve their business objectives within budget and on schedule.
• Possess industry experience in many key industries, including Health & Medicine, Insurance, Banking, Financial Services, Advertising & Marketing, Information Technology (or IT), Telecommunications, and Manufacturing. Key assets include great analytical skills, quick-learner, detail-oriented, great communication skills, great work-ethic, and dedication to tasks.
• Database and Applications design, development, management
• Database, IT Systems solution, and Applications performance analyses and enhancements

TECHNICAL SKILLS

• Database Systems: Microsoft SQL Server (v7.0, 2000, 2005, 2008, 2008R2, 2012, and 2014); Oracle Database Server (Oracle 8i, Oracle 9i, 10G, and 11G); and Microsoft Access (2000, 2003, 2007, and 2010).
• OS Platforms: Microsoft Windows (NT, 2000, XP, Vista, Server 2003, Server 2008, Server 2008R2, Server 2012, Windows 7, and Windows 8); Novell NetWare (v5.x, v6.x, and v7.x); Apple Macintosh (v7.x, v8.x, v9.x, v10); and Linux
• Database Computing Concepts and Technologies: RDBMS, OLTP, OLAP, Very Large Databases (Data Warehouse), Data Intelligence and Reporting (SSAS and SSRS), High - Availability (Database Clustering, Database Replication, Database Mirroring, and Log Shipping), Database Design and Programming (SQL, T-SLQ, PL-SQL, Database Design, and Batch Processing), Security (Encryption and Auditing), Data Import/Export and ETL (DTS and SSIS), and Connectivity (ADO, ADO.NET, RDO, DAO, RDS, OLEDB, and ODBC).
• Network Concepts and Technologies: LAN, WAN, Wi-Fi, Routing, Switching, Ethernet, DSL, Cable Modem, Protocols (TCP/IP, NetBEUI, NetBIOS, PPP, PPTP, HTTP, HTTPS, SMTP, POP, and AppleTalk), Directory Services (Active Directory, NDS, and LDAP), Network Services (DNS, and DHCP), TCP/IP Tools (FTP, SFTP, Telnet, and SSH), and Security (Firewall, ACL, and Filtering).
• Languages: Visual Basic, VB.Net, ASP, ASP.NET, HTML, XML, SOAP, HL7, JavaScript, Java, C/C++, Pro*C, PL/SQL, SQL, Stored Procedure, VBA, and Macros.
• Design and Management Tools: Microsoft Visual Studio, SQL Server Management Studio, and Microsoft Visio.
• Productivity Software: Microsoft Office Suite (XP, 2003, 2007, and 2010)
• Application software: Oracle Forms & Reports; Microsoft (Word, Excel, PowerPoint, Project); Corel WordPerfect (v4.x-v6.x and WordPerfect 97).
• Financial Application software: SAP, Microsoft Dynamics GP, and BPC
• Web Technologies: Web Servers (Microsoft IIS) and Web Browsers (Microsoft IE, Netscape Navigator, Mozilla FireFox, and Google Chrome).
• Web and Design Software: Macromedia design suite Dreamweaver (v4.0, UltraDev v4.0 and MX 2004, Flash v5.0, and FireWorks v4.0) and Adobe graphic design suite (Illustrator v9.0, ImageReady v3.x, and PhotoShop v6.0).

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Senior SQL Server DBA

Responsibilities:

• Migrated older SQL server version (2008, 2008R2) SQL Server 2014
• Deploy codes, script, bug fixes and/or SSRS to production for the application teams
• Upheld the SLA established by the business for all resolved tickets in the ServiceNow application
• Troubleshoot and fix failed database backup process via SQL Backup (Redgate)
• Identify, troubleshoot and fix “long running jobs” using monitoring tool Solarwinds (DPA) tool

Confidential, Birmingham, AL

Senior SQL Server Developer

Responsibilities:

• Migrate existing Access queries to T-SQL queries and/or Stored Procedure
• Modify current SQL Server queries to Stored Procedure
• Advise the business on what type of server to purchase for their new production environment
• Configured SSRS for their production environment
• Migrated their SSRS development environment to production environment

Confidential, Alpharetta, GA

Senior SQL Server DBA/Data Architect

Responsibilities:

• Created a SQL Server Build specification for each application to be built and migrated.
• Worked with the Wintel team to ensure the OS (Windows Server 2008R2 or 2012) are ready for SQL Server installation and configuration per SQL Server team specifications
• Implemented varies types of SQL Server builds, which includes:
• Stand alone
• Log shipping
• Clustered (High Availability)
• DR (SAN Replication)
• Worked with the app team to ensure their application are able to connect to the database
• Migrates databases from Confidential data center to Synchrony Financial data centers
• Coordinated SQL Server memory and backup remediation on all the servers, the SQL team was responsible for, therefore cutting down on the amount of trouble ticket received by the team.
• Documented the build environment for every application

Confidential, Marietta, GA

Senior SQL Server DBA/Data Architect

Responsibilities:

• SQL Server (including SSIS and SSRS) setup, configuration, and administration.
• Database Replication configuration and management.
• Database Security planning, design, implementation, and management.
• Database Backup and Restore Operation design, implementation, and management.
• Database Disaster Recovery Strategy design, implementation, testing, and management.
• Create and deploy reporting services reports
• Created SQL Server Integration Services (SSIS) to perform multiple data extractions.
• Monitors and ensure smooth running of BI applications and systems.
• Windows 2003 and 2008 R2 Server systems administration and support.
• Work with SAN administrators to trouble shoot issues and LUN/Volume size requirements
• Help users with issues pertaining to Great Plains and BPC.
• Redesign the entire database backup solution to adhere to the business retention policy
• Implement Kerberos affectively to resolve latency issues with the SSRS environment globally
• Migrated an Oracle 10G database server to SQL Server 2008 R2 database server
• Migrated over 100 database servers and application servers to Hyper-V clustered environment to reduce Physical hardware footprint in the datacenter.

Confidential, Duluth, GA

SQL Server DBA

Responsibilities:

• SQL Server (including SSIS, SSAS, and SSRS) setup, configuration, and administration.
• Database Replication configuration and management.
• Database Security planning, design, implementation, and management.
• Database Backup and Restore Operation design, implementation, and management.
• Database Disaster Recovery Strategy design, implementation, testing, and management.
• Database and System performance-tuning, monitoring, and optimization.
• Server Jobs setup, monitoring, and management via SQL Server Management Studio
• Provides Database Development Support to development teams, ensuring adherence to best practices and corporate standards.
• Also, provides backup support for the following IT operations and support services:
• Windows 2003 Server systems administration and support.
• Administration of key application systems, including Microsoft SharePoint, Business Objects, and other web applications.
• Manage deployments of service packages and BI applications from Development environment to UAT, Stage, and Production environments.
• Monitors and ensure smooth running of BI applications and systems.