SUMMARY:

• Microsoft Certified Professional with over 6 years of proven experience in SQL server database administration, database design, performance analysis, development and maintenance by providing 24/7 support on production and non - production environments. Fl exible and dedicated to performing at the highest-level of monitoring, tracking and resolving database incidents and requests . Excellent interpersonal and communication skills, Self-motivated that can work independently under minimal supervision, Able to prioritize and manage multiple tasks under pressure.
• Installation, configuration, upgrading, maintenance and administration of SQL server 2014/2012/2008 R2/2008/2005 in standalone and cluster environments.
• Applying service packs, hotfixes and cumulative updates.
• Worked with developers on efficient database design and developed database objects such as tables, constraints, views, indexes, procedures, triggers, and functions.
• Developed, implemented and periodically tested database backup and recovery plans, scheduled automated jobs, and created alerts and operators.
• Checked status of automated daily, weekly and monthly system maintenance tasks.
• Experienced in performance monitoring and tuning using Profiler, Performance Monitor, and Dynamic management views and functions.
• Evaluating CPU, Disk I/O and memory related bottlenecks, blocking and deadlocks.
• Implemented security by creating logins, users, roles, and assigning permissions according to principle of least privilege.
• Migrated Data to/from different data sources by developing SSIS packages.
• Experience of High Availability solutions over mission critical systems on cluster environment using Mirroring and Log Shipping.
• Knowledge of Windows server, active directory and SAN disc configurations.
• Self-motivated, creative, team player, dedicated, well organized, detailed oriented.
• Strong communication skills, both verbal and written, throughout my career.
• Worked closely with talented team, senior managers and vendors.

TECHNICAL SKILLS:

RDBMS: MS-SQL Server 2014, 2012, 2008R2, 2008 and MS-Access, Windows Server 2003, 2008, 2012

Configuration Tools: SQL Server Surface Area Configuration, Reporting Services Configuration, SQL Server Configuration Manager, Microsoft Database Upgrade Advisor

Development Environment: SQL Business Intelligence Development Studio, SQL Server Management Studio, Enterprise Manager, Query Analyzer, Export / Import (DTS), SSIS

Programming Languages: C++, Visual Basic, Java

PROFESSIONAL EXPERIENCE:

Confidential, Lanham, MD

SQL Server DBA

Responsibilities:

• Ensure all Production databases are running efficiently 24/7.
• Installed, Configured, Upgraded, and applied patches and application tools for production and development servers.
• Involved in Physical and logical database modeling, capacity planning, sizing and database growth projections.
• Developed, tested, and deployed database objects as requested by clients.
• Strong experience designing, documenting, and implementing backups and recovery strategies.
• Reviewed server configuration, monitored server resource utilization, ensured optimal performance of server, and monitored and optimized query execution.
• Monitored automated maintenance processes to ensure continued optimal performance of servers.
• Implemented SQL server security by maintaining authentication modes, configuring object permissions and assigning roles to users.
• Performed day to day DBA activities such as monitoring SQL Server health, checking scheduled job status, disk space, blocking issues and addressed user requirements.
• Used DBCC commands to troubleshoot issues related to database consistency.
• Setting up disaster recovery solutions using log shipping, mirroring and always on windows clustering for high availability.
• Worked in Active/Active and Active/Passive clustered environment.
• Developed SSIS package that export various data from operation database to data warehouse.

Environment: MS-SQL server 2008/2012/2014 ; windows server 2003/2008, SSIS, SSRS, VMware instances, SAN storage, MS clustering services.

Confidential, Alexandria, VA

Jr. SQL Server DBA

Responsibilities:

• Applied service packs/Hotfixes and created documentation for tracking and SQL server installation purposes.
• Developed RDBMS objects such as; tables, schema, views, functions triggers and index design.
• Implemented backup and recovery processes to ensure data safety.
• Created maintenance plans to perform index de-fragmentation, re indexing and update the index statistics.
• Designed and implemented policies and conditions to ensure server and database level security.
• Involved in performance tuning using Profiler, DMVs, and activity monitor.
• Managed storage environment by planning and including additional storage to maintain optimal size and provided growth statistics.
• Rebuild/Reorganize indexes at regular intervals for better performance.
• Performed maintenance plans including; rebuilding and reorganizing index regularly.
• Ensured server and database security by auditing logins and user account permissions.
• Involved in development of automated daily, weekly and monthly system maintenance tasks such as database backup, integrity, replication, indexing and database mail configuration.

Environment: SQL server 2005/2008/2012, Visual studio 2008/2010, MS access SQL Profiles, Query analyzer, windows server 2003, SAN storage.

Confidential

Database Specialist

Responsibilities:

• Organized and accurately entered data in to different computer programs.
• Efficiently analyze data for errors and report problems with data.
• Generate responses to requests for information and statistics.
• Installed and updated different application software and operating systems.
• Implement policies and procedures to insure security.
• Knee attention to detail, highly efficient in finding errors and inconsistencies.
• Excellent data entry, record keeping and time management skills

Environment: MS-Access, MS-Excel, SQL server 2005, Windows server 2003