OBJECTIVE:

• Obtain a challenging technology position in an organization that enables growth and offers advancement opportunity with increasing job knowledge.

SUMMARY

• Has over 12+ 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.

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, Confidential -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 - West Palm Beach, Florida

Senior SQL Server Developer\ DBA

Responsibilities:

• Created ETL packages with different data sources (SQL Server, Flat files, Excel, Oracle, DB2, and Teradata) and loaded the data into target tables by performing different kinds of transformations using SSIS.
• Installed, Configured and administer several SQL Server 2014 instances
• Troubleshoot and resolve process hanging issues on the SSIS servers
• Scheduled jobs and alerts using SQL Server Agent and configure database mail for job failure

Confidential

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.
• 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.

Confidential, Atlanta, GA

SQL Server DBA

Responsibilities:

• Created SSIS packages to perform various business functions and processes.
• Performed complete database design, development, test, and implementation in support of business intelligence applications and solutions.
• Participated in the creation and delivery of data-driven applications for corporate users.
• Performed database backup/Restore planning and management, using WinRar to export zipped backup files to various locations, improving availability for developers.
• Moved Moss 2007 into a virtual environment on both the front end and back end.
• Developed database standards documentation, with focus on coding standards and rules and regulations regarding change deployment.
• Provided support of Microsoft BI application environment, including monitoring of all upgrades and service pack installations.

Confidential, Atlanta, GA

SQL Server DBA/Data Architect

Responsibilities:

• Worked extensively on the SQL queries, stored procedures and functions. Wrote complex stored procedures.
• Built and managed the MS SQL Server Databases and Infrastructures including upgrading the department from MS SQL 2000 to the MS SQL 2005.
• Used SQL Server Reporting Service (SSRS) to publish data to the end user via HTML, PDF, Excel, and CSV formats.
• Scheduled jobs were created to execute multiple DTS package to extract data from multiple Rockwell and Avaya switches from the southeast regions call centers.
• Created SQL Server Integration Services (SSIS) to perform multiple data extractions from IEX TotalView application.
• Developed new or maintain existing databases based on specifications.
• Shared knowledge by effectively documenting work.
• Experience in designing and implementing high availability strategies using Database Backups, replicationmodels, mirroring, and database fail-over clustering.
• Respond quickly and effectively to production & development issues and taking responsibility for seeing those issues through resolution.
• Resolve database performance issues, database capacity issues, and etc.
• Manage security of database structures and corporate data held within databases.
• Develop database procedures, triggers and SQL scripts for development teams.
• Maintain database changes from Development, QA to Production.
• Assist in the definition and implementation of database standards.
• Monitor databases for errors and perform problem determination when necessary.
• Worked on mission critical projects and fast paced environments

Confidential, Tucker, GA

SQL Server DBA/Developer

Responsibilities:

• Run daily, weekly and monthly reports for management consumption.
• Performed complete Database design, development, and implementation.
• Import Different Business Unit data into the eForm (Web Application).
• Architect and implemented an " ANF Tracking " Web application for the Finance Department in Atlanta.
• Import/export patient demographics in different format (i.e. text, ascii, HL7, etc.).
• Automate repetitive tasks.
• Performed database schema (i.e. tables, views, indexes, relationships, etc.) definition, design, implementation, and modification on SQL Server 2000.
• Developed, implemented and administer high availability database fail-over clustering.
• Performed Database Search and Query Strategy design, implementation, testing, and optimization.
• Performed Stored Procedures development and testing.
• Configured and maintained transactional and merge replication for several different production environments.
• Performed Database Migration Plan management, testing, and execution.
• Performed Database Backup/Restore planning and management.
• Performed database software recommendation, setup, and configuration.
• Architect and implemented an " TOROL Tracking " database application for the Atlanta Support Center

Confidential

Oracle DBA Administrator / Developer

Responsibilities:

• Managed Oracle 8.x/9i database systems. Key responsibilities included the following: General Database Administration, Performance Tuning, Capacity Planning, and Data Backup and Recovery operations.
• Installed and provided technical support for in-house application using Oracle Developer/2000 runtime reports and forms.
• Performed extensive tuning and optimization of database and application code (e.g. stored procedures, user-defined functions, triggers, etc.) to boost operating efficiency. Built numerous triggers to implement business rules for auditing purposes.
• Designed and implemented Oracle reports for input into management reports.
• Created a multi-user Oracle Application Test Environment with updated data from the Production system to test new software patches before deployment into the Production environment.
• Performed periodic refresh of the data in the Test Environment with data in the Production system.
• Designed a fully integrated user interface using Oracle forms to interact with the database systems.
• Provided SQL, Pro*C, PL/SQL and database support to a team of Java, XML and C++ developers performing Web development.
• Installed and configured Oracle Enterprise Manager 8i (OEM) to handle jobs scheduling, event monitoring, capacity planning, and email and pager notification for all Oracle databases, including two Oracle 8.0.6 relational database systems running on UNIX host servers.
• Was responsible for designing data backup strategy for a 24x7 mission critical database application using RMAN.
• Performed SQL tuning and memory adjustment, by gathering and interpreting statistics about the critical areas of databases via use of dynamic performance views and data dictionary tables.

Confidential, Atlanta, GA

SQL Server Developer / Data Architect

Responsibilities:

• Performed all aspects of project planning and management.
• Architect and implemented an "Employee Benefits" database application for Cingular's HR department.
• Performed Data Discovery and Data Requirements Gathering.
• Performed complete Database design, development, and implementation on SQL Server 2000.
• Performed database schema (i.e. tables, views, indexes, relationships, etc.) definition, design, implementation, and modification.
• Performed Database Search and Query Strategy design, implementation, testing, and optimization.
• Performed Stored Procedures development and testing.
• Configured and maintained the transactional replication between the production environments.
• Performed Database Report design and implementation, using Active Reports.
• Performed Data Import/Export Plan design, implementation, and execution.
• Performed Database Migration Plan management, testing, and execution.
• Performed Database Backup/Restore planning and management.
• Performed database software recommendation, setup, and configuration.

Web Developer/Database Administrator

Confidential

Responsibilities:

• Redesigned and implemented the company's internal "Publishing" database running on a proprietary legacy database system.
• Performed complete Database design, development, and implementation. These included database schema (i.e. tables, views, indexes, relationships, etc.) definition, design, and implementation.
• Performed Database Search and Query Strategy design, implementation, testing, and optimization.
• Performed Stored Procedures development and testing, as well as Database Report design and implementation.
• Performed Data Import/Export Plan design, management, testing, and execution.
• Designed and implemented the company's website for the Spring 2001 season, utilizing software and design tools such as Dreamweaver and Adobe Photoshop. (A portfolio of my previous projects can be furnished upon request.)