Sql 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 2012/2008R 2/2008/2005/2000 . Experience in Production, Test and Development Environment Monitoring, diagnosing problems Performance Tuning/Optimization Backup & Recovery. Experience with MS SQL Server in a VLDB environment 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. Knowledge of SQL Server Clustering. Working experience with SQL Server Integration Services (SSIS) using ETL tools. Working experience with 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 Experience with VMware Working experience also includes installing, configuring, and administering the above operating systems and Active Directory
SQL Server Tools Used: SQL Server Management Studio, Enterprise Manager, Activity Monitor, Upgrade Advisor, Query Analyzer, SQL Profiler, Database Tuning Advisor and Index Tuning Wizard, Business Intelligence Development Studio, SQL Configuration manager Reporting Services Configuration manager
Third-Party Tools Used: SQL Doctor----Health check, Patch Analyze, backup Analyze, quick indexing (Defragment indexes), Diagnostic Tools, Administrative Tools.
Microsoft Office: 2003/2007
PROFESSIONAL EXPERIENCE:
Confidential, Arlington, VA
SQL Database Administrator
Responsibilities:
- Performs all duties as assigned and necessary.
- Capacity Planning for Servers and Databases
- SQL Server 2008R2, 2008, 2005 & 2000 in development, test, and production environment.
- Windows Server 2003, 2008R2 and Active Directory 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, 2008 R2
- Create database users, implement privileges, grant user permission, and perform auditing.
- Active involvement with capacity planning to plan for proper hardware based on growth patterns, database activity, and future project.
Confidential, Washington, DC
SQL Database Administrator
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.
