SUMMARY:

• Result Driven SQL Server DBA with 11+ years of Database Administration and IT experience with an In - depth understanding of SQL Server, administration, design, development, and implementation on a fast paced 24/7 environment using SQL Server 2014/ 2012/2008 R 2/2008/ 20005 /2000 on Operating Systems. Possess a high level of energy, integrity and ethics with an exceptional ability to deliver outstanding bottom line results, which improves productivity. Strong experience with installation, configuration, performance Monitoring and tuning, Maintenance of SQL Server and in database backup and recovery procedures.
• Experience on MS SQL Server 2014/2012/2008/ R2, 2005 and 2000, installation, configuration and management of standalone & failover Clustered Servers in different nodes
• Upgraded SQL platforms from MSSQL server 2005 to MSSQL Server 2008/R2 & 2012
• Applied Patches and Service Packs on SQL Server 2005 and 2008
• Undertook database consistency and integrity checks after software upgrades and run different types of maintenance tasks
• Created and maintained Databases, Tables, views, triggers, stored procedures, schemas, indexes, creating logins and users, creating Roles and managing user permissions and more
• Managed security including creation/alteration of principals, grant of server/DB roles and permissions on various database objects by using appropriate security models
• T-SQL coding and testing: functions, views, triggers, cursors, and stored procedures, My SQL
• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity.
• Implemented different types of Replication Models like Snapshot, merge and Transactional and or peer-to-peer
• Set up full, differential and T-log backups as a routine operations and restore procedures during disaster period by giving administrative support to recover full database with a minimal data loss
• Hands on experience in high availability solutions like Log shipping, mirroring on editions of SQL Server2012/ 2008R 2/2008/2005.
• Created and administered packages using SQL Server Integration Services (SSIS), Scheduling Jobs, and Sending Alerts using Database Mail.
• Responsible for troubleshooting, configuring and managing the system
• Extensive experience in Capacity planning, Performance Tuning, Troubles shooting procedures.
• Experience in SQL Server Reporting Services and Microsoft share point, power shell Documenting disaster recovery plans and day-to-day operations for reference and reporting purposes
• Good experience in managing database maintenance plans such as back up database task; check database integrity task, maintenance cleanup task, and shrink database rebuild & reorganize index tasks among others.

PROFESSIONAL EXPERIENCE:

Confidential, Baltimore, Maryland

Database Engineer/ SQL Server DBA

Responsibilities:

• MS SQL Server 2014/2012/2008/ R2, 2005 and, installation, configuration and management of standalone & Clustered Servers
• Ensure security of SQL Server systems by auditing logins and user account permissions, implementing server hardening "Best Practices", and implementing encryption as requested by clients.
• Encrypting database and server TDE native Database encryption and 3rd Party Software Encryption
• SQL native Database Encryptions and third party Encryption software, Server Auditing, Documentation
• Review server configuration, monitor and optimize query execution, monitor server resource utilization ensure optimal performance of server.
• Diagnose network, storage, Perform task automation with OS and native Database tools and third part tools like IDERA / REDGATE
• Implemented different types of Replication Models like Snapshot, merge and Transactional and peer-to-peer.
• Design, Install and configure clustering for SQL Server instance on SQL2005, SQL2008 and SQL 2012, Always ON Availability groups.
• Responsible for disaster recovery planning for SQL Servers. Implemented database mirroring for constant availability of insurance and systems
• Developed database maintenance plan for database backups and recovery, reorganizing data and database integrity checks.
• Responsible for daily operational management and troubleshooting of MS SQL 2005/2008/2012 /2014. Troubleshoot MS SQL servers using native tools profiler, activity monitor, and performance monitor as well as VM tools.
• Perform maintenance plan of Databases, Tables, views, triggers, stored procedures, schemas, indexes, creating logins and Ensured appropriate storage for the DBMS, allocation of disk space, Performed maintenance of Databases, Tables, views, triggers, stored procedures, schemas,
• High availability Replication, Mirroring, Log shipping always on in different nods
• Created and administered packages using SQL Server Integration Services (SSIS), Scheduling Jobs, and Sending Alerts using Database Mail.
• Responsible for troubleshooting, configuring and managing the system
• Extensive experience in Capacity planning, Performance Tuning, Troubles shooting procedures.
• Documenting disaster recovery plans and day-to-day operations for reference and reporting purposes
• Configure Linked server with Oracle and DB2
• Database upgrading patching and install Service pack
• Good experience in managing database maintenance plans such as back up database task; check database integrity task, maintenance cleanup task, and shrink database rebuild & reorganize index tasks among others.
• Utilize SQL Server Management Studio to manage Analysis Services objects (perform back-ups, processing, and so on), also to create new objects directly on an existing Analysis Services instance by using scripts
• Generate database scripts for the configuration defined in an existing database design file. Used this primarily to administer instances of Analysis Services, SQL Server, Integration Services, and Reporting Services.
• Installed/re-installed, configured, migrated and maintained windows SQL server 2003/05/08/2012 and Windows XP 2008/drivers enhanced and later operating systems on different machines for several purposes.
• Utilize SQL Server Management Studio to manage Analysis Services objects (perform back-ups, processing, and so on), also to create new objects directly on an existing Analysis Services instance by using scripts.
• Used SQL Server Management Studio to provide an Analysis Server Scripts to develop and save scripts, Data Mining Extensions (DMX).

Environment: SQL Server 2008,SQL Server 2005, SQL Server 2000, Windows 2012, 2008R2, Windows 2003/2000 Enterprise, SQL Server Clusters, Windows 2003, VMWare

Confidential

Database Engineer/ SQL Server DBA

Responsibilities:

• MS SQL Server 2014/2012/2008/ R2, installation, configuration and management of standalone & Clustered Servers
• Encrypting database and server TDE native Database encryption and 3rd Party Software Encryption
• SQL native Database Encryptions and third party Encryption software, Server Auditing, Documentation
• Review server configuration, monitor and optimize query execution, monitor server resource utilization ensure optimal performance of server.
• Diagnose network, storage, Perform task automation with OS and native Database tools
• Implemented different types of Replication Models like Snapshot, merge and Transactional
• Design, Install and configure clustering for SQL Server instance on SQL2005, SQL2008 Responsible for disaster recovery planning for SQL Servers. Implemented database mirroring for constant availability of insurance and systems
• Developed database maintenance plan for database backups and recovery, reorganizing data and database integrity checks.
• Responsible for daily operational management and troubleshooting of MS SQL 2005/2008/2012 /2014. Troubleshoot MS SQL servers using native tools profiler, activity monitor, and performance monitor as well as VM tools.
• Perform maintenance plan of Databases, Tables, views, triggers, stored procedures, schemas, indexes, creating logins and Ensured appropriate storage for the DBMS, allocation of disk space, Performed maintenance of Databases, Tables, views, triggers, stored procedures, schemas,
• High availability Replication, Mirroring, Log shipping always on in different nods
• Created and administered packages using SQL Server Integration Services (SSIS), Scheduling Jobs, and Sending Alerts using Database Mail.
• Responsible for troubleshooting, configuring and managing the system
• Extensive experience in Capacity planning, Performance Tuning, Troubles shooting procedures.
• Documenting disaster recovery plans and day-to-day operations for reference and reporting purposes
• Configure Linked server with DB2
• Database upgrading patching and install Service pack
• Good experience in managing database maintenance plans such as back up database task; check database integrity task, maintenance cleanup task, and shrink database rebuild & reorganize index tasks among others.
• Utilize SQL Server Management Studio to manage Analysis Services objects (perform back-ups, processing, and so on), also to create new objects directly on an existing Analysis Services instance by using scripts
• Generate database scripts for the configuration defined in an existing database design file. Used this primarily to administer instances of Analysis Services, SQL Server, Integration Services, and Reporting Services.
• Installed/re-installed, configured, migrated and maintained windows SQL server 2003/05/08/2012 and Windows XP 2008/drivers enhanced and later operating systems on different machines for several purposes.
• Utilize SQL Server Management Studio to manage Analysis Services objects (perform back-ups, processing, and so on), also to create new objects directly on an existing Analysis Services instance by using scripts.
• Used SQL Server Management Studio to provide an Analysis Server Scripts to develop and save scripts, Data Mining Extensions (DMX).

Environment: SQL Server 2014,SQL Server 2012, Windows 2012, 2008R2, Enterprise, SQL Server Clusters, VMWare

Confidential

SQL Server DBA

Responsibilities:

• Develop and monitor automated maintenance processes to ensure continued optimal performance of client servers.
• Provide 24/7 support for client SQL Server implementations.
• Develop, test, and deploy SPROCs, UDFs, and other database objects as requested by clients.
• Develop, monitor, and test database backup processes.
• Ensure security of SQL Server systems by auditing logins and user account permissions, implementing server hardening "Best Practices", and implementing encryption as requested by clients.
• Review server configuration, monitor and optimize query execution, monitor server resource utilization ensure optimal performance of server.
• Implemented different types of Replication Models like Snapshot, merge and Transactional and or peer-to-peer.
• Design, Install and configure clustering for SQL Server instance on SQL2005, SQL2008 and SQL 2012, Always ON.
• Responsible for disaster recovery planning for SQL Servers. Implemented database mirroring for constant availability of insurance and systems
• Rewrote and tuned long-running SQL queries to cut execution time, ease database load and improve scalability
• Daily Database backup and recovering at regular intervals to make sure the backup and restore is proper for SQL Servers 2005/2008/2012
• Developed database maintenance plan for database backups and recovery, reorganizing data and database integrity check.
• Responsible for daily operational management and troubleshooting of MS SQL 2005/2008/2012 . Troubleshoot MS SQL servers using native tools such as profiler, activity monitor, and performance monitor as well as VM tools.
• Perform maintenance of Databases, Tables, views, triggers, stored procedures, schemas, indexes, creating logins and Ensured appropriate storage for the DBMS, allocation of disk space, Performed maintenance of Databases, Tables, views, triggers, stored procedures, schemas, indexes, creating logins and users, creating Roles and managing user permissions and more
• Responsible for the design, deployment and control of MS SQL in a virtual VM environment.
• Used SQL server management studio and reporting tools to design, and manage SQL environments.
• Export and Import data from other data sources like flat files using SQL server Import/Export wizard and SSIS.
• Responsible installation, configuration, maintenance of the SQL 2005/2008/2012 servers.
• Ensure sure that all levels of the migration and deployment processes are going as intended on the SQL 2005, 2008, and 2012 servers.
• Join daily troubleshooting, escalation, meetings, keep tasks on the plate up to date and make sure they are completed on a timely manner.
• Export and Import data from other data sources like flat files using SQL server Import/Export wizard and SSIS.
• Developed complex stored procedures, triggers and views using T-SQL
• Worked closely with developers to resolve issues.

Environment: SQL 2012,SQL Server 2008,SQL Server 2005, SQL Server 2000, Enterprise and Windows 2012, Windows 2008R2, Windows 2003/2000 Enterprise, SQL Server Clusters, Windows 2003, VMware

Confidential

SQL Server DBA/Data Analyst

Responsibilities:

• Developed ETL processes critical in support of SQL server linked with clinical research data,
• Generated business intelligence artifacts.
• Developed an automated process for server management.
• Developed SSIS Packages for importing and exporting the data
• Proactively managed the performance of the clinical research database including monitoring query performance, automated jobs and security.
• Responsible for daily operational management and troubleshooting of MS SQL 2005/2008/2012 . Troubleshoot MS SQL servers using native tools such as profiler, activity monitor, and performance monitor as well as VM tools.
• Administered database server security ensuring appropriate and minimal required user access.
• Installed new DBMS versions and applied maintenance fixes supplied by the DBMS vendor,
• Maintaining/cleaning the operating system
• Design, Install and configure clustering for SQL Server instance on SQL2005, SQL2008
• Ensured appropriate storage for the DBMS, allocation of disk space, enabled the DBMS to work with storage devices
• Designed, deployed and managed SQL environment using SQL server management and reporting tools.
• Responsible installation, configuration, maintenance of the SQL 2005/2008/2012 servers.
• Responsible for database migration from MS SQL 2005 to MS SQL 2008
• Fine-tuned complex SQL queries by analyzing the query execution plans.
• Plan, design and \scheduled Database Maintenance & Administrative Tasks on a daily and weekly basis and follow up and troubleshoot problems
• Tuned databases to perform efficiently, by managing databases using the options to grow or shrink database files and monitor the size of the transaction log. Used clustered and non-clustered indexes when needed.
• Responsible for backup and restore and recovery process of the SQL 2005/2008 servers.
• Migrated data from SQL Server to Oracle using DTS and SQL loader
• Designs and run the database design tool in interactive mode to define database configuration values and save them to a new database design file or to an existing file.
• Generate database scripts to create the database objects for database design tools in silent mode with command-line parameters to edit or validate an existing database design file.
• Generate database scripts for the configuration defined in an existing database design file. Used this primarily to administer instances of Analysis Services, SQL Server, Integration Services, and Reporting Services.
• Installed/re-installed, configured, migrated and maintained windows SQL server 2003/05/08 and Windows XP 2008/drivers enhanced and later operating systems on different machines for several purposes.
• Utilize SQL Server Management Studio to manage Analysis Services objects (perform back-ups, processing, and so on), also to create new objects directly on an existing Analysis Services instance by using scripts.
• Used SQL Server Management Studio to provide an Analysis Server Scripts to develop and save scripts, Data Mining Extensions (DMX).

Environment: SQL Server 2008,SQL Server 2005, SQL Server 2000, Windows 2008R2, Windows 2003/2000 Enterprise, SQL Server Clusters, Windows 2003,VMWare

Confidential

SQL Server DBA

Responsibilities:

• Database development including table, view, and index design.
• Implemented backup processes to ensure data safety.
• Installed, configured, migrated, maintained and managed SQL Server 2000 & 2005 in development, test, and production environment. Also took full responsibility for SQL 2005 cluster design, installation and configuration.
• Provided installation and maintenance support on operating systems like windows SQL 2000/2005.
• Plan, design and \scheduled Database Maintenance & Administrative Tasks on a daily and weekly basis and follow up and troubleshoot problems
• Developed ETL packages to integrate multiple data streams.
• Proactive management of database performance using Profiler, PerfMon and DMVs. Implementing server hardening.
• Responsible for backup and restore and recovery process of the SQL 2005/2000 servers.
• Managed users access to database objects.
• Provided Administrative support for multiple large databases in, production, development and test environments for various types of databases.
• Installed, Configured, and Managed SQL Server 2000 & 2005 in development, test, and production environment
• Performed management of SQL server security, indexes, disk space allocation planning, managing logins and users, meet up with user groups, etc.
• Provided installation and maintenance support on operating systems like windows server 2000/2003/provide system security support to protect operating system and databases from security threats
• Performed Import &Export data from Flat file, CSV file, and Access to/from SQL Server Database using DTS, SSIS

Environment: SQL Server 2005/ 2000, SQL Server 2000, Windows 2003/2000 Enterprise, SQL Server Clusters, Windows 2003,