We provide IT Staff Augmentation Services!

Database Administrator Resume

Arlington, VA

SUMMARY:

I am a qualified candidate can provide SQL Server Database Administration support for production and development environments and have strong Experience to perform database monitoring and tuning, database backups, migrations, and more . I am looking for a SQL Server DBA position which is fit with my knowledge and personality.

KEY SKILLS/EXPERTISE:

  • Ability to tailor a system to meet specific organizational needs.
  • Excellent communication and interpersonal skills.
  • Ability to adjust with new environments.
  • Have the ability to work as part of a team and independently
  • Self - motivated, Detail-oriented, proactive in communicating progress and issues
  • Able to manage time too effectively to meet deadlines and prioritize workload.

TECHNICAL SKILLS:

Experience & Knowledge: Installation & Configuration of SQL Server Software 2008R 2/2005/2000. Experience in Production, Test and Development Environment Monitoring, diagnosing problems Performance Tuning/Optimization Backup & Recovery. Security Management. Database Log Shipping Admin/Implementation. Database Mirroring Admin/ Implementation. Database Replication SQL Server Database Migration, upgrade. T-SQL, Store Procedures, Trigger, Functions, Working Experience with ASP, ASP.NET. Working experience with SQL Server Integration Services (SSIS) using ETL tools. Knowledge of SQL Server Reporting Services (SSRS)

Operating Systems: Working experience on Operating Systems (O/S) include Windows Server 2008, 2008 R2/2003, 2003 R2, Windows XP/7 Working experience also includes installing, configuring, and administering the above operating systems

Hardware/Storage: SAN, NAS

SQL Server Tools Used: SQL Server Management Studio, Enterprise Manager, Upgrade Advisor, Query Analyzer, SQL Profiler, Database Tuning Advisor and Index Tuning Wizard, Business Intelligence Development Studio, SQLCMD SQL Configuration manager

Third-Party Tools Used: SQL Doctor----Health check, Patch Analyze, backup Analyze, quick indexing (Defragment indexes), Diagnostic Tools, Administrative Tools., 2003/2007

PROFESSIONAL EXPERIENCE:

Confidential, Arlington, VA

Database Administrator

Responsibilities:

  • Performs all duties as assigned and necessary. Capacity Planning for Servers and Databases
  • SQL Server 2008, 2005 & 2000 in development, test, and production environment. Windows Server 2003, 2008
  • SQL Server 2000 to 2005/2008/2008 R2 SQL Server 2005 to SQL Server 2008/2008 R2
  • SQL databases into MS SQL Server 2000, 2005, and 2008
  • Applied SP (Service Pack) on SQL Server 2000, 2005, 2008, 2008 R2 Applied Patch on Windows Server 2003, 2003 R2
  • Create database users, implement privileges, grant user permission, and perform auditing.
  • Strong on database Monitoring and Performance tuning Scheduled jobs to automate different activities such monitoring database health, disk space, job alert, index monitoring, stats monitoring etc
  • Read and write T - SQL, Trigger, and Stored-Procedures Assisted Database Developers to optimize SQL queries and Stored Procedures
  • Strong knowledge and working experience in Database Backup and Disaster Recovery
  • Experienced with Point-in-Time Recovery Restored Database from backup
  • Used DBCC to check database conditions, fix database corruption, rebuild indexes and other database Maintenance purposes as well
  • Working experience with SQL Server Integration Services (SSIS) using ETL tools.
  • Exported and Imported databases and database objects using Export/Import Wizard.
  • Active involvement with capacity planning to plan for proper hardware based on growth patterns, database activity, and future project.
  • Installed, Configured and Maintained Database Mirroring. Configured Log Shipping as Standby database from Production database for Reporting purposes. Database Replication: Snapshot and Transactional
Database Administrator

Confidential, Washington, DC

Responsibilities:

  • Working experience in Production & Development environments.
  • Performs all duties as assigned and necessary. Involved in capacity planning, hardware & software requirements.
  • Installation, Configuration, Upgrade SQL Server 2000, 2005 & 2008R2 Installed and Configured & Manage Operating Systems/Windows Server 2003 & 2008.
  • Migrated databases from SQL Server 2000 to 2005 and 2005 to 2008 in test and production environment
  • Develop plans for and be able to execute disaster recovery for SQL server database systems.
  • Develop and maintain Database backup strategy.
  • Monitor Database performance issues and Server issues.
  • Troubleshoot the issues, implements preventive actions.
  • Used DBCC to check physical and logical consistency of database Implementation and management of database security for users.
  • Advocate proper data access and database maintenance.
  • Write and Review store procedures to ensure optimal performance, security purposes and recurring tasks.
  • Possesses a very good understanding of database architectural design, modeling and development methodology.
  • Working experience with SQL Server Integration Services (SSIS) using ETL tools.
  • Export & Import data from Oracle Database, MySQL, and Access Database including flat files like text, excel.
  • Effectively articulate database requirements to non-database teams, document strategies to resolve business requirements using database structures.

Hire Now