We provide IT Staff Augmentation Services!

Sql Server Dba Resume

Greensboro, NC

PROFILE

A certified SQL Server Database Administrator (DBA) with 10+ years of IT experience and 5+ years of Database Administrator experience; a proven track record of progressive experience, team leadership and technical skills. Strong business and technical vision with effective skills to allow close work with senior management. Ability to manage multiple complex projects for internal and external customers. Innovative and creative problem solver, who is results oriented. Works well with a team and independently. TECHNICAL SKILLS

SQL Server 2000/2005/2008 JAVA Script Visual Basic
Problem Documentation Active Directory T-SQL

  • MS Access Server Installation Tape backups

EXPERIENCE

Confidential,Greensboro, NC March. 2008 – Present
SQL Server Database Administrator

Worked as SQL server DBA to support Project LightSpeed, a new initiative by AT&T to provide U-verse TV, DVR, Internet, Phone services. Responsible for maintaining multiple databases across multiple instances, on dedicated hardware in windows environment. Worked closely with system administrators to plan server hardware purchases, for upgrades and expansions.

  • Responsible for 20+ servers using SQL Server 2000, 2005 & 2008.
  • Setup log shipping for production databases to disaster recovery servers.
  • Configure and maintain snapshot, transactional and merge replication environments.
  • Create stored procedures, setup traces, DTS and SSIS packages.
  • Handle new installations and patch upgrades
  • Create policies for database upgrades, maintenance plan implementation and capacity planning
  • Create SQL agent jobs to update and extract data.
  • Manage logins and user permissions.
  • Extract Transform Load (ETL) development using SQL Server 2008 Integration Services (SSIS)
  • Develop, deploy and monitor SSIS Packages including upgrading DTS to SSIS.
  • Identified resource intensive queries by analyzing Profile traces.
  • Create logical and physical database design, data structures, and implemented large databases.
  • Create reports using SQL Server Reporting Services (SSRS).
  • Perform full Backups and transaction log backups. Restore them whenever necessary; create back up strategies and schedule them for execution.
  • Complete migration project from SQL Server 2000 to 2005 and 2008 using upgrade advisor.
  • Revise backup scheduling and maintenance plans, develop stored procedures & triggers.
  • Provide 24/7 critical production support for data issues and given appropriate solutions.
  • Rebuild indexes on tables to reduce fragmentation.

Confidential,Chicago, IL May. 2006 – March. 2008
SQL Server Database Administrator

BCBS is one of the largest health insurance companies in the mid west region. Worked on Medical Loss Ratio, Sunset and Large Group Contract Generation projects. Worked in SQL Server 2000/2005 environments Worked in a team of four DBA’s to provide 24/7 support to business critical Databases.

  • Create backup routines and schedules, perform database restores and run consistency checks from SQL Server and application.
  • Create logins and roles with appropriate permissions.
  • Monitor and resolve production systems performance issues
  • Develop and maintain stored procedures, triggers, DTS packages and job scheduling
  • Develop, deploy and monitor SSIS Packages including upgrading DTS to SSIS.
  • Supported 24x7 production environment.
  • Write custom queries to support direct marketing campaign activities
  • Review queries in application code for optimization and handle performance monitoring
  • Setup log shipping and revise maintenance plans.
  • Periodic checking of all databases with DBCC commands for maintaining data consistency and integrity.
  • Prepare and document database backup & maintenance plans.
  • Perform data extraction and migration activities for non-production databases.
  • Administer security for server logins (Windows and SQL Accounts).
  • Daily monitoring of the database performance and network issues.

Confidential,Chicago, IL Feb. 2003 – May 2006
Network Administrator

Worked as a Network Administrator to maintain emails servers, print server and workstations. Performed network troubleshooting to isolate and diagnose complex network problems. Resolved technical support issues related to applications, Internet and LAN. Managed user accounts by assigning appropriate permissions using Active Directory.

  • Install, repair, and maintain all servers in the company infrastructure; apply update patches.
  • Install, repair, and maintain network equipment and cables.
  • Keep all PCs and servers at the latest version of virus scan software.
  • Install and trouble shoot Microsoft products on PCs.
  • Setup Remote Access Service (RAS) and Virtual Network Computing (VNC)
  • Using VNC on a regular basis for remote administration of both servers and workstations.
  • Conduct requirements analysis, design, implementation and testing.
  • Configured the server and user permissions, and document installation and settings for assistance and troubleshooting.
  • Perform backup and restore Images using Norton Ghost.
  • Administer Windows Server 2003 as per business requirements; manage Active Directory, applying patches etc.
  • Assign permissions to users by using active directory.
  • Train users on software and equipment usage including any third party software that was required to full fill the business need.

Confidential,AL Jun. 2001 - Dec. 2002
Help Desk Support Specialist

At this position I provided second line of support for various technical issues related to products and applications. I responded to inquiries and requests for assistance with organization\'s computer systems or PCs and resolved customer inquiries. Maintained written documentation for each call; escalated complex problems to the next level of support; communicated efficiently and effectively with customers. The set of responsibilities I performed are:

  • Handle incoming work orders, emails, and phone calls for customer base of over 200.
  • Install and troubleshoot a variety of software packages in a Windows environment utilizing remote access software and desk-side visits.
  • Setup and troubleshoot various printers, scanners, and other peripherals.
  • Assist users with account setup, data backups, and general usage of desktop and laptop PC’s.
  • Computer lifecycle replacements utilizing Norton Ghost.
  • Laptop VPN configuration and support using Cisco products.
  • Deliver written weekly reports to supervisor.
  • Work with Helpdesk Ticketing systems, Excel spreadsheets, and various databases.
  • Maintain systems to meet or exceed security requirements.

Confidential,Doha Qatar 1997 - 1999
Computer Technician

  • Built, configured, and maintained Windows workstations, and provided system support and updates.
  • Trained new personnel through one-on-one sessions in PC usage and network browsing.
  • Installed printers, rewired data centers, and recommended hardware updates for clients PC’s.
  • Supported a total of over 100 users.

EDUCATION

Bachelor of Science, Network and Communications Management

PROFESSIONAL CERTIFICATIONS

  • MCITP Certified (Database Administrator)
  • MCTS Certified (SQL Server 2008, Implementation and Maintenance)

Hire Now