SUMMARY

An enthusiastic and detail-oriented Database administrator / Developer in highly transactional database servers, fluent in T-SQL scripting, versatile engagements in development, testing and production environments wif overwhelming successes in accomplishing individual and team projects, certified as Microsoft SQL Server Database Administrator and Microsoft Server Database Developer is seeking for Database Administrator/Developer Position.

• More TEMPthan five productive years of experience as SQL Server Database Administrator/Developer.
• Experienced in hardware and software benchmarking pre-installation of SQL Server.
• Installation, Configuration, Maintenance, Upgrade and Patching of SQL Server of diverse versions and editions.
• Working extensively on TFS, Visual Studio, Web Application Servers, CRM servers.
• Experienced in System Analysis, Design, Development & Support of MS SQL Servers 2008, 2008R2, 2012, 2014,2016 in Production and Development Server Environments.
• Experienced wif logical modeling and physical implementation of Relational and Multidimensional Databases.
• Experienced wif disaster recovery implementations including backup & recovery, log shipping and mirroring.
• Experienced wif implementation of diverse High Availability approaches including Failover Clustering, Replication and AlwaysOn, depends on business specifications.
• Experienced in dealing wif efficient security strategies wif respect to Principal of Least Privilege (P.L.P) and bringing it to implementation and administration.
• Experienced wif Transparent Data Encryption (TDE).
• Creating database Objects like tables, views, store procedures, triggers, indexes, functions….
• Experienced in creating maintenance plans: Checking integrity of teh databases, Updating statistics, Building and Reorganizing Indexes, Maintenance cleanup…
• Virtualizing SQL Server on virtual machines like VMWare. me TEMPhas also fascinating experiences wif SQL Azure and teh Cloud.
• Experience wif Data Migration tools such as; SSIS, Detach/Attach, Import/export, DB Copy wizard, Backup/restore, BCP and so on.
• Experience wif Configuring and Automating Jobs. Creating and configuring Jobs, Alerts, SQL Mail Agent.
• Experience in error-handling, troubleshooting and performance Tuning using SQL Tools such us; DMO's, profiler, activity monitor, tuning adviser, Query analyzer, execution plans, Trace, statistics, index tuning wizard and so on.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Working knowledge in SSIS, SSRS and SSAS
• Experience in supporting Very Large databases (VLDB) and troubleshooting teh problems.
• Report Writing and administrating a dedicated SQL Server Reporting Server (SSRS)
• Being certified in SQL Server Database Development and worked on a dedicated development environment, me TEMPhas solid scripting experience on DDL, DML, DCL wif high granularity and any reasonable level of sophistication, depends on our business need.

TECHNICAL SKILLS

Databases: SQL server 2008, 2008R2, 2012 and 2014, 2016, Oracle Database 11g and 12c.

Windows Server: Window Server 2012R2/2012/2008R2/2008/2003.

Virtualizing MS SQL Server on VMWare.

Languages: Fluent in T-SQL, Moderate in C++, PL/SQL.

SQL Server Tools: Confidential Studio, Visual Studio 2005/2010, SSDT, Enterprise Manager, Query Analyzer, Profiler, Performance Monitor, DTS, Server Network Utility, Database Tuning Wizard, Index Tuning Wizard, SSIS, SSAS, SSRS, Microsoft Clustering Services.

Third-Party Tools: Erwin, Red Gate, Spotlight, and Idera.

Pentaho Data Integration: Version 5.0, 5.1

Database Query Tools: MS SQL Server Query Analyzer, SQL Profiler, ETL, SQL Server Confidential Studio and Enterprise Manager.

PROFESSIONAL EXPERIENCE

Confidential

SQL Server DBA/Developer, Richmond, VA

Responsibilities:

• Providing 24x7 dedicated production support for SQL Server problem resolution and server outages.
• Responsible for large scale of database migration from SQL server 2005 to 2008r2, 2012, 2014 and to 2016.
• Responsible for Creating stored procedures, tables, views, functions, triggers and indexes.
• Involved in disaster recovery and high availability technologies implementation documentations, pre-implementation analyses.
• Automating jobs for multiple tasks from performance monitoring, maintenance, backup to purging files and collecting information to analyze overall performance and benchmarks of its hardware and system resource availability.
• Verify backups and error logs on teh servers and troubleshoot any failures or alert problems, and open trouble tickets if necessary to work wif technicians from other departments.
• Responsible for Installing, configuring and maintaining SQL Failover clustering for two production environments.
• Responsible for configuring and maintaining Transactional, Snapshot and Merge replication in production environments.
• Involved in improving database performance using DMVs, DVs, SPs, SQL Profiler, Trace Flags, Execution plan and Index Tuning Wizards.
• Responsible for Server and Database security managements. Creating roles, assigning permissions, Granting, denying and revoking access to corresponding roles, logins and users.
• Working wif developers so as to optimize performances of user defined queries. Mode of communication is technically TFS next to discussing teh issues together.
• Scheduling jobs and alerts using SQL Server Agent. Administrating Microsoft Operation Manager (MOM) 2005 in an existing IT infrastructure.
• Used System monitor to find teh bottlenecks in CPU, Disk me/O and memory devices and improved teh database server performance.

DBA/Developer

Confidential, New York, NY 

Responsibilities:

• Responsible for Installing and configuring SQL Server 2005 and 2008 on Windows 2003 and 2008 servers.
• Scheduled Full and Transactional log backups for teh user created and system databases in teh production environment using teh Database Maintenance Plan Wizard.
• Worked wif SQL DBA team and SQL Developers to optimize teh SQL queries and stored procedures.
• Created transactional replication for teh reporting applications.
• Installed and configured SQL server 2008 Reporting Services (SSRS), created user roles, managed security built reports and deployed them to production. Worked wif configured SSRS to monitor all jobs on daily basis, fixed teh failed jobs and re-run them.
• Provided 24 X 7 dedicated supports to hundred and eight Production, development and clustered servers.
• Extensively used BCP and BULK INSERT to import and export data from flat files, Excel and MS Access to MS SQL Server databases.
• Used DBCC commands to troubleshoot issues related to database consistency.
• Daily monitoring of two-node active-passive SQL cluster in a host environment.
• Applied service packs and security fixes for all SQL Servers, and provided database administration support.
• Involved in upgrading SQL Server 2005 to 2008 and from SQL Server 2008 to SQL Server 2012.
• Performed teh database backups for production, test and development environments.
• Created teh backup and restore strategy for teh all three environments.
• Worked wif teh database optimization, Performance tuning and index tuning for optimization of queries.
• Setup Database Maintenance Plans to reorganize indexes, re-indexing and update teh index statistics on teh production databases.
• Implemented trigger and stored procedures and enforced business rules via checks and constraints.