We provide IT Staff Augmentation Services!

Database Administrator Resume

Franklin, TN

Technical Profile:

  • 6+ years experience as a SQL Server Database Administrator
  • DBMS used: MS SQL Server 2000/2005/2008/2008 R2, Oracle 10g/11g Database, PostgreSQL 8.2, MySQL, Firebird
  • Operating Systems: Windows 2003/2008/2008 R2 Server, Linux/Unix(RHEL, Ubuntu)
  • Extensive experience with database migrations, backups and disaster recovery, and database virtualization
  • Expert T-SQL skills writing complex queries and developing stored procedures, functions, and triggers
  • Expert performance tuning skills, including query and index tuning
  • Strong data modeling and physical database design skills
  • Strong SSIS skills
  • Possess basic skills building SQL Server Analysis Service solutions
  • Experience creating and supporting highly-available database solutions (log shipping, mirroring, replication, clustering)
  • Intermediate C#.NET skills and related technologies:ADO.NET,Entity Framework
  • Possess a diversified technical background with Enterprise systems and a proven ability to implement new and emerging technologies
  • Extensive experience working with development and managing of in-house developed systems
  • Expertise in full project life cycle development, implementation, and integration
  • 24/7 on-call production database support experience

Work Experience

Data Services DBA

  • Comprehensive database management and development using SQL Server in an agile environment with weekly builds.
  • Played a central role in stabilizing database environments, improving on maintenance tasks, development practices and design.
  • Supported production, development, and QA environments
  • Assumed the role of Application DBA focusing on T-SQL development and architecture.
  • Performed query and index tuning for performance optimization
  • Performed code reviews of code written by report writers and other developers
  • Enforced company development standards
  • Migrated DTS packages to SQL Server 2008 Integration Services
  • Developed complex SSIS packages
  • Automated refresh to QA environments using Compellent SAN snapshots
  • Provided assistance to Java Developers, Business Analysts, and EDI Analysts
  • Administered MySQL based CRM application and the synching process between MySQL and MS SQL Server (triggers/stored procedures based)
  • Worked with developers, architects, and system administrators to identify bottlenecks and performance issues with the application cluster
  • Supported transactional replication between servers
  • Completed Red Flags training (regulations in financial industry)

Backup Administrator 2010

  • Developed disaster recovery plan (backing up over 100 servers, user data, SQL Server databases) using Symantec Backup Exec

Database Administrator 2005 – 2009

  • Developed very effective disaster recovery policy, including high availability (log shipping, mirroring)
  • Performed database migration and server consolidation
  • Performed upgrade of MS SQL Server 2000 to MS SQL Server 2005 and MS SQL Server 2008
  • Resolved performance issues of SQL Server by changing database physical design, T-SQL code optimization, hardware level changes
  • Wrote and altered stored procedures, functions, triggers, views, complex SQL-queries
  • Performed, improved and automated processes of importing into database information from outside licensing and registering official organizations (car registrations, land and property information, etc) in different formats including flat files, xml, dbf, Microsoft Access, etc using DTS and SSIS packages
  • Administered an Oracle database using Oracle 10g
  • Administered a MySQL database running a regional forum
  • Implemented server side configuration enabling individual taxpayers and companies send their tax forms over the internet
  • Took part in the pilot project providing tax account information to taxpayers over the internet
  • Created and deployed complex reports
  • Created SSAS solutions for users in Analytical department

Languages

English, French, Russian

Hire Now