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