SUMMARY:

• Highly motivated, competent Information technology professional with the ability to communicate effectively with administration and all levels of personnel.
• Goal oriented, organized and a multi - tasked individual.
• Proven team leader, providing motivation, training and support for staff.
• Extensive understanding of the network and data administration, and desk top user support as well as network system design, database development and process implementation
• The qualities of Analysis, Dependability and Thoroughness have enabled me to advance and excel through programming, database design and network system design..

SUMMARY OF TECHNICAL QUALIFICATIONS:

• 6 months Delphi
• 3 years experience using ‘C’
• 10+ years SQL DBA, TSQL, Transact Repl, DTS, SSIS (6.5,7.0,2000,2005,2008) and MS Access (VBA, Reporting), (2.0, 95, 97, 2000, 2003)
• 4 years VB (4.0, 5.0, 6.0)
• 4 years Crystal Reports (5-7)
• 5 years Exchange Admin 2003, 2007
• 5 years Domain Admin, Active Directory, (2000, 2003)
• Working Knowledge of: 370 Assembler, Cobol, CICS, JCL
• Connectivity: ODBC, DAO, RDO, ADO

SYSTEMS USED:

• 10yrs DOS, 13yrs (Win 3.1, NT, XP, Vista, Win7),
• 10yrs (Win NT, 2000, Win 2003 (32 and 64bit)
• 2 years Clustering, Active / Active, Active / Passive
• Intel 32, x64 and Itanium
• 2yrs (PRIME, STRATUS)
• 1 year UNIX (AIX)

PROFESSIONAL EXPERIENCE:

SQL DBA

Confidential, Raleigh, NC

Responsibilities:

• Support 50 VMs, 36 SQL Servers, 600+ Databases
• ASP environment responsible for sql databases and supporting PM applications in five timezones
• Perform server and database tuning, monitoring process performance and trouble-shooting issues using performance monitor, profiler, query execution plan, WUG
• Created and managed server and database security access
• Design and develop Servers, database systems, tables, views, T-SQL, Stored Procedures, Triggers, UDF, DTS, establish database integrity
• Application Support
• Worked with application developer’s teams to resolve performance problems with dot net programs and or vendor related scheduling software.
• HIPPA Compliant

SQL DBA

Confidential, Durham, NC

Responsibilities:

• Perform server and database tuning, monitoring process performance and trouble-shooting issues using performance monitor, profiler, query execution plan, SpotLight
• Created and managed server and database security access
• Design and develop database systems, tables, views, T-SQL, Stored Procedures, Triggers, UDF, DTS, establish database integrity
• Worked with application developer’s teams to resolve performance problems with dot net programs and or vendor related scheduling software.
• Domain Admin

SQL DBA

Confidential, Durham, NC

Responsibilities:

• Supported bank database issues, responding to servers around the world to resolve database performance problems, failovers, blocking, deadlocks, replication, backups, tsql performance & etc…..

Sr SQL DBA

Confidential, Durham, NC

Responsibilities:

• Project DBA/Architect, build and managing multi-terabyte dbs, Clustered SQL Servers (2005, 2008), multiple instances, OLTP (3 - 5 mil per month, billions of data rows), Transactional Replication, Reporting Services, 2005, 2008
• Work with vendors, Solution Integrators, System Architects, Project Managers and Users to implement a high profile, high availability transactional claims database systems.
• Provide support to production DBA's for projects implemented
• Perform database server and database, tuning, monitoring process performance and trouble-shooting monitoring process performance and trouble-shooting using performance monitor, profiler, query execution plan
• Created and managed server and database security access
• Design and develop database systems, tables, views, T-SQL, Stored Procedures, Triggers, UDF, DTS, SSIS, establish database integrity
• Worked with middleware team and vendor in testing data schemas and software functions
• HIPPA Compliant

Sr SQL DBA/Developer

Confidential, Atlanta, GA

Responsibilities:

• DBA/Architect, build and manage multi-terabyte health systems and statics dbs, Clustered SQL Servers(2005, 2008), multiple instances, Transactional Replication, Reporting Services, 2005, 2008
• Worked development team, implemented system improvements and managed data integrity
• Perform database server and database, tuning, monitoring process performance and trouble-shooting monitoring process performance and trouble-shooting using performance monitor, profiler, query execution plan
• Created and managed server and database security access
• Design and develop database systems, tables, views, T-SQL, Stored Procedures, Triggers, UDF, DTS, SSIS, establish database integrity
• Tested functionality stored procedures as it relates to business rules
• HIPPA Compliant

Sr SQL DBA/Developer

Confidential, Morrisville, NC

Responsibilities:

• DBA/Architect, build and manage SQL Servers (2000, 2005), multiple instances, Reporting Services, 4TB
• Worked with development team, implemented system improvements and managed data integrity
• Perform database server and database, tuning, monitoring process performance and trouble-shooting using performance monitor, profiler, query execution plan
• 24x7x365 production environment and on call db support
• Created and managed server and database security access
• Design and develop database systems, tables, views, T-SQL, Stored Procedures, Triggers, UDF, DTS, SSIS, establish database integrity
• Created database maintenance plans
• Created maintenance plans for differential backups and recovery using sequel and LiteSpeed
• Tested functionality stored procedures as it relates to business rules
• HIPPA Compliant

Sr SQL DBA-Dev/System Engineer

Confidential, Kennesaw, GA

Responsibilities:

• Worked with development team, implemented system improvements and managed data integrity
• Perform database server and database, tuning, monitoring process performance and trouble-shooting monitoring process performance and trouble-shooting using performance monitor, profiler, query execution plan
• Created and managed server and database security access
• Managed windows clustering, 64bit itanium
• Design and develop database systems, tables, views, T-SQL, Stored Procedures, Triggers, UDF, DTS, SSIS, establish database integrity
• 24x7 high volume OLTP production environment and on call db support
• Created database maintenance plans
• Created maintenance plans for database transaction log backups and recovery using sequel
• Perform patch installations maintenance
• Database Architect / Modeling / DBA, 2005 Reporting Services
• Design, install and manage network systems (firewall, switches, IP Schema).
• Network Admin, Domain Admin, Active Directory, Exchange Admin, DBA/Architect
• Built and manage domain 2003, exchange 2007, Clustered SQL Server(2000, 2005), ), dns, dhcp, term, virus, gateway, web, app, backup systems and hardware
• Tested functionality stored procedures as it relates to business rules

Sr SQL DBA-Dev/System Engineer

Confidential, Atlanta, GA

Responsibilities:

• Worked with senior management in setting major project deliverables and deadlines
• Worked with in developing / implementing system improvements and managing data integrity
• Design, install and manage network systems (firewall, switches, IP Schema).
• Network Admin, Domain Admin, Exchange Admin, DBA/Architect
• Built and manage domain 2003, active directory, exchange 2003, SQL Server(2000), dns, dhcp, term, virus, gateway, web, app, backup systems and hardware
• Perform database server and database, tuning, monitoring process performance and trouble-shooting monitoring process performance and trouble-shooting using performance monitor, profiler, query execution plan
• 24x7x365 production environment and on call db support
• Created and managed server and database security access
• Design and develop database systems, tables, views, T-SQL, Stored Procedures, Triggers, UDF, DTS, establish database integrity
• Created database maintenance plans for database backups
• Database Architect / Modeling / DBA
• Managed windows clustering, 32bit
• Created normalize database systems with referential integrity and cascade triggers
• Designed Provider DB tracking: Provider and Ancillary Demo, Address, Credentialing, Hospital, Insurance, Education, Contracts, Networks, Work History information and etc…
• Designed and Issue Tracking DB to monitor all provider related state issues.
• Setup database file groups (primary, data, index, log and temp) on various disk volumes and controller channels
• Perform data manipulation, data washing, data transformation on various data files: benefit, fee schedule and claim files to and from other insurance companies
• Create routines to automate data task
• Use VB and Access Basic(VBA), DAO, ADO, T-SQL, Create Stored Procedures, Triggers, UDF, DTS, MS SQL Server 2000
• Maintain a data warehouse of claims data for reporting and data analysis
• Perform patch maintenance
• Created maintenance plans for database transaction log backups and recovery using sequel
• Adapt to new development environments and changing business requirements, learn new systems and technologies, and find creative and scalable solutions to difficult problems
• Resolve networking issues including firewall configuration and dedicated circuits to other content production locations.
• Supervise project implementations for mid-sized to large technical projects with team members from various functional groups within the IT-Ops organization.
• Tested functionality application and database as it relates to business rules
• HIPPA Compliant

IS Manager/SQL DBA-Dev

Confidential

Responsibilities:

• Managed programmer system analysts assigned to supporting the managed care claims system.
• Worked with senior management in setting major project deliverables and deadlines
• Built and manage domain 2000, SQL Server(2000), term, backup systems and hardware
• Database Architect / Modeling / DBA
• Manage applications, electronic data interfaces for access multiple platforms.
• Perform database server and database, tuning, monitoring process performance and trouble-shooting
• Created and managed server and database security access
• Design and develop database systems, tables, views, T-SQL, Stored Procedures, Triggers, UDF, DTS, establish database integrity
• Setup database file groups (primary, data, index, log and temp) on various disk volumes and controller channels
• Perform data manipulation, data washing, data transformation on various data files: benefit, fee schedule and claim files to and from other insurance companies to load into our claims system error free etc…
• Setup database file groups (primary, data, index, log and temp) on various disk volumes
• Perform patch maintenance
• Created maintenance plans for differential database backups and recovery using sequel
• Use VB and Access Basic, DAO, ADO, T-SQL, Create Stored Procedures, Triggers, DTS, MS SQL Server 2000
• Create routines to automate data task
• Maintain a data warehouse of claims data and performed data analysis and reporting
• Integrate Managed Care IS staff with Promina IS staff
• Create applications to automate user input of claims data on a UNIX system
• Managed and operate Promina Health Plan Medical management systems
• Participate on Implementation and Interface team for Diamond BBX (Claims), Compass, Macess (Imaging) & Quality First projects
• Created database and user interfaces to access data from SQL Server & RISC box using TCP/IP.
• Lead large-scale technical projects, working with staff and vendors to gather requirements, scope technical efforts, determine solutions, set up project tasks/plans, and then implement those solutions
• HIPPA Compliant

Software Developer

Confidential, Atlanta, GA

Responsibilities:

• Responsible to write, debug, and optimize complex stored procedures for critical applications.
• Design systems for companies utilizing the services of a telemarketing company to track the sales of their product.
• Use VB4, Access Basic 7, C, DAO, RDO, T-SQL and MS SQL 6.5