Sql Server Data

RAMATULLAH MOHAMMED

Email: *********@*****.***

Phone: 240-***-****

SUMMARY

Around 8 years of Database Administration and Development experience working on MS SQL Server 2014/2012/2008 R2/2008/2005 Production, Development and Testing in Clustered and Stand-alone Server Environments.

Extensive experience in various editions of SQL server like SQL Server 2008/ 2008R2 / 2012 /2014 /2016 express edition and SQL server 2008/2008R2/2012/2014/2016 enterprise edition.

Deep understanding and working experience of SQL Server (SQL 2008/SQL 2008 R2/2012 / 2014), includes installation, configuration & maintenance of standalone and Clustered Servers [Active/Active and Active/Passive Cluster Design].

Knowledge of SDLC (Software Development Life Cycle) and development practices (ranging from Traditional to Agile) and JIRA-based Scrum development life cycle practices

Core experiences in Data Migration, Installation, Indexes, Disaster Recovery, Performance Tuning, Backup and Recovery, Database Security, High Availability Solutions, Database Upgrades patches, SSMS, Integration Services, Database Mirroring, Log-Shipping, Database Migration.

Ability to ensure the technical integrity of corporate databases by protecting against the loss or misuse of information and designing backup/recovery strategies.

Experience in upgrading SQL server software to new versions and applying service packs and patches & Strong knowledge and working experience with SharePoint 2010.

Proficient in Cloud/Azure with experience of Azure Services, PaaS, IaaS, and Migrated from premises databases and Legacy products on Azure, deployed products on Azure, Setup development and test environment on Azure.

Extensive experience on Cloud Computing like Azure/AWS.

Implementation of Database Maintenance Plans for database consistency & integrity such as Integrity check, Rebuilding indexes, Update statistics, clean up history etc. to run the databases efficiently.

Experience in using tools like Database Engine Tuning Advisor, SQL Profiler, Index Tuning Wizard and Windows Performance Monitor for monitoring and tuning MS SQL Server performance.

Optimizing and Performance Tuning such as Query Optimization, Performance Tuning using execution plan, Profiler, Database Tuning adviser and Windows Performance Monitor tools to resolve Dead Locks or long running queries and slow running server.

Experience in implementing SQL Server security and Object permissions like maintaining Database authentication modes, creation of users, configuring permissions and assigning roles to users based on the client requirements.

Worked with XML files, to configure the .NET application as well as PowerShell code

Analyzing consistency of databases by using DBCC commands and worked on DMVs and dynamic management functions for finding out long running queries.

Implementing high Availability (HA) and Disaster Recovery (DR) Features (Always On, Clustering, Database Mirroring, Log Shipping and Replication).

Create and set-up Database maintenance plans & Jobs for Database monitoring, maintenance and Automation.

Knowledge of Microsoft Best Practices with regards to configuration of SQL data/log, tempdb, backup drive locations.

Worked on Linked and Remote Servers to run queries between SQL servers and other data sources using ODBC, OLE DB drivers

Experience in creating and scheduling SSIS/DTS packages

Good experience in writing and debugging SQL Server stored procedures/triggers and documenting issues/resolutions of SQL Server Applications.

Extensive experience in using BCP to import/export data from different sources of data into SQL Server Databases.

Experienced on Unix/Linux scripting.

Worked knowledge of operating systems (Windows/Linux)

Experience in an operational environment providing support, involving coordination with release Management, Ticketing System and Change management.

Experience in creating SSIS, SSRS, SSAS packages and also writing complex T-SQL / Stored Procedures, Joins / Views / Triggers / Scripts.

Expertise in writing T-SQL scripts for creating stored Procedures, Triggers, Cursors, and Tables, hands on experience in writing and debugging Stored Procedures, Triggers, Cursors, Complex queries using T-SQL Scripts and Batch files.

Amplified ETL skills to build and maintain SSIS packages, SSRS, SSAS and interfaces with Oracle and also very strong with cloud/Azure databases.

Experience in building Data Integration, Workflow Solutions and Extract, Transform and Load (ETL) solutions for data warehousing using SQL Server Integration Service (SSIS).

Experience with Adhoc reporting, Parameterized, Custom Reporting using SSRS for daily reports.

Expertise in creating the Cubes and Dimensions building, deploying, processing and maintaining Cubes using SQL Server Analysis Services (SSAS).

Experience in Data Warehouse Modeling with SQL Server Analysis Service (SSAS).

Technical skills

Databases

MS SQL Server 2000/2005/2008/2008R2/2012/2014, Oracle, DB2, MS ACCESS 2000/2003/2007

Languages

T-SQL, C, C++, C#, vb.net, JAVA,ASP.NET, Power Shell, XML,PL/SQL

Operating System

Windows 2000/2003/2008/XP/VISTA/7

Business Intelligence Tools

SSIS (SQL Server Integration Services), SSAS (SQL Server Analysis Services), SSRS (SQL Server Reporting Services)

Third party tools

Spotlight, Commvault, Redgate, Idera(SQL Safe, Diagnostic Manager), Litespeed,UC4

Applications

Microsoft Office Suite, Visual Studio 2005/2008/2010, Visual Source Safe, TFS, AZURE.

ROYAL BANK OF CANADA, Jersey City, NJ May 2016 to Present

Role: SR MSSQL SERVER DBA

Responsibilities:

Provide project support of engineering based decisions and scope to assist the customer with over all layouts, design and installation of DB system, Configuration, Migration, Upgrades and Patching.

Designed and Developed data migration strategy between on premise and Azure environments

Managed MS Azure accounts utilized for disaster recovery/storage Platforms.

Configure off-site backups in Microsoft Azure cloud storage

Disaster recovery database deployment with Log shipping utilizing Azure VM with SQL Server 2014

Responsible for supporting & troubleshooting issues with databases using 2014/2016 enterprise edition.

Performed various day to day activities of SQL data base administrator on SQL server 2016 enterprise edition.

Implemented scripts to find out the orphan users in the servers. Successfully migrated logins and users between multiple servers.

All activities around monitoring service components and reporting such as performance, capacity, license usage and DB consistency.

Recommend and Review Backup and Recovery Strategies based on Service Level Agreement (SLA) and test plan for failure scenario.

Design, Configure and deploy offsite DR solution using Database mirroring and log shipping.

Designing and hardening SQL Server Security (Server hardening, Auditing and user/group access monitoring).

Implementing high Availability Features (Always On, Clustering, Database Mirroring, Log Shipping and Replication).

Install, configure and Administering SSRS, SSIS and SSAS.

Troubleshoot long running queries by using various methods including PERFMON, SQL Profiler, Database Engine Tuning adviser and 3rd party tools.

Investigate performance issues and make recommendations to resolve them.

Perform root cause analysis and troubleshooting any database issues (such as locking, blocking, deadlock etc.)

Implement storage management strategies.

Install, configure and use third party backup and monitoring tools such as Red Gate.

All day-to- day activities to keep the service up and running to agreed SLAs and to be compliance with Dominion IT control policy such as health checks, monitoring ticket queues, changes, End user requests and automation of processes.

All activities relating to preventing services problems occurring and the general adherence to SLAs by proactive means such as patch management, performance tuning, capacity management, DB indexes maintenance, DB security, DB integrity checks and DB recovery.

Maintaining & updating database inventory.

Optimized the performance of queries with modification in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes wherever necessary.

Communicates all pertinent activities and all status updates to all necessary parties, including but not limited to, department heads, team members and end users

Developed and automated daily, weekly and monthly counts of Claims by Scheduling the SQL Job.

Effectively interface between the business and technology teams in order to ensure business objectives are met and communicated to senior management

Environment: Windows Server, Windows Enterprise Server 2014/2016, IIS Server, SSIS, SSRS, SSAS, Visual studio, T-SQL, AZURE, Share point, Dell Power Edge 8450, VSS, SQL Server Enterprise Edition 2014/2016.

Caxton Associate, NY August 2014 to March 2016 Role: SQL Server DBA

Responsibilities:

Maintaining 400+ SQL Servers with multiple instances in different environments (RTE, DEV, Pre-prod and Production) and proficiency in deploying new code base release to UAT and Production Environments.

Performed day to day activities of SQL data base administrator on SQL server 2014 enterprise edition.

Implementation of automated jobs for database backup on a weekly and monthly basis, based on the volatile nature of database tables and indexes.

Troubleshooting and resolving day to day issues such as job failures, transactional log issues, blocking and deadlock issues, permission issues etc.

Migration, creation and configuration of databases based on the specifications sent by the client and meet the SLA (Service Level Agreement).

Rebuilding / monitoring the indexes at regular intervals for better performance.

Created proper Indexes on different tables that improve the performance of T-SQL queries on the database.

Using TSQL for developing stored procedures to enhance the performance of the database system.

Maintaining the Database Consistency with DBCC commands.

Monitoring Jobs & Alerts, CPU utilization, Data & log file sizes, and troubleshooting space issues.

Set up Database Maintenance Plans to reorganize, rebuild and update the index statistics for better performance.

Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions.

Configured log shipping, database mirroring and replication for synchronization of databases.

Worked extensively on Extraction, Transformation, Loading data from Oracle, DB2, Access, Excel, Flat Files and XML using DTS, SSIS. Created and deployed various reports using SSRS.

Creation of logins, roles, assigning permissions and mapping users as per the client's request.

Performing SQL Server service pack and Windows Service pack upgrades.

Scheduling JOBS (Daily, Weekly, and Monthly) as per the client request.

Performing database Refresh (Native tool, Tivoli TSM - TDP) in different environments like Prod, Pre-Prod, Dev, RTE.

To analyze long running slow queries and tune the same to optimize application and system performance.

Automated messaging services on server failures, for task completion and success.

Executed stored procedures requested by the application team to accomplish short-term business goals.

Configuring TDP Nodes and installed TDP-SQL in standalone and Cluster environments.

Handling Memory configurations for SQL Server and responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.

Running Database tuning wizard and continuously monitoring and updating the Backup and Recovery strategy.

Maintained the physical database by monitoring and optimizing performance, data integrity and SQL queries for maximum efficiency using SQL Profiler.

Implementation of Database maintenance plan for Database consistency & Integrity

Monitoring SQL server performance to find dead locks and blocking to improve the performance.

Analyzing database health and consistency by using DBCC Commands and DMVs.

Monitoring Jobs & Alerts, CPU utilization, Data & log file sizes, Space availability in Storage Devices.

Environment: Microsoft Windows Server 32/64 bit, DB2 10.5/11.1 Linux, IBM Data Studio, Windows Enterprise Server 2012/2014, T-SQL, SQL Server Enterprise Edition 2014.

Medtronic, Edison, NJ May 2013 – July 2014 Role: SQL Server DBA

Responsibilities:

Managing a high availability clustered MS SQL instances containing system critical databases.

Migration of data from on premise to AWS cloud infrastructure using DMS.

Setting up data replication from on premise to AWS cloud using data migration service and schema conversion tool.

Experience working on Amazon RDS, Creating DB Instance running on the Microsoft Database Engine and performing DBA activities on AWS.

Modifying the DB parameter group and providing support for AWS databases

Installed and administered Three-Node Cluster Active/Active/Passive on Microsoft Windows Server 2012 Enterprise Edition on SAN environment.

Performed day to day activities of SQL data base administrator on SQL server 2012 enterprise edition.

Created different maintenance plans to monitor the database for Day to day backups, DBCC checks, indexing and similar tasks.

Involved in installation, configuration and complete administration of different versions of MS SQL Server.

Wrote T-SQL statements for retrieval of data and Involved in performance tuning of TSQL queries and Stored Procedures

Configured jobs, alerts, notifications and E-mails for system errors, fatal database errors, disk space report and hardware error and set up database mail to send out alerts and notifications from SQL server to external users.

Supported lots of application and database deployments for various departments in the organization.

Created and Modified Tables, Store Procedures, Views, Indexes, User-defined Functions, and Triggers as required.

Administered the MS SQL Server security by enforcing security policy and following best industry practices.

Optimized Database performance by tuning queries, proper Index using, Database Wrote store procedures as well as checking others code for efficiency.

Administered and supported Production environments for various applications.

Administered the MS SQL Server by created user logins with appropriate roles, dropped and locked the logins, monitored the user accounts, creation of groups, granted the privileges to users and groups.

Monitored MSSQL Server performance using native and 3rd party tools and managed the use of disk space, memory and CPU.

Monitoring Databases and troubleshooting SQL Server performance issues using Extended event, SQL Server Profiler, Trace, DTA and Index tuning wizard

Performing Database integrity checks using DBCC utilities

Scheduling SQL Server jobs to monitor disk space, CPU activity and Index fragmentation

Create and Manage users, roles, security at object level, data encryption

Installed, Configured and maintained Always on High Availability Group in SQL Server 2012

DR planning processes including Peer-To-Peer Replication, Log Shipping and Database Mirroring

Migrated MS SQL Server 2008R2 to MS SQL Server 2012.

Provides support for multiple applications using Microsoft SQL RDBMS Platforms.

Monitoring Databases and troubleshooting SQL Server performance issues

Designed and implemented comprehensive Backup plan and disaster recovery strategies

Installed, Configured and Maintained Cluster Fail-Over Servers in SQL Server 2008 & 2012

Imported and exported data from Excel and BCP to SQL Server Database

Created Jobs for database maintenance.

Environment: Windows server IIS 5.0, Window Server 2003 IIS 6.0,Windows Enterprise Server 2012, Crystal Report, T-SQL, AWS, SQL Server Enterprise Edition 2012, Microsoft Operation Manager ( MOM), Visual Source Safe.

RxLogix Corporation, Princeton, NJ DECEMBER 2011-APRIL 2013 Role: SQL Server Developer/ DBA

Responsibilities:

Installed, configured and managed SQL server 2008 & 2012 in Development, Test and Production Environment.

Performed day to day activities of SQL data base administrator on SQL server 2012 enterprise edition.

Applied SQL Server Cumulative Updates & Service Packs and Define/Recommend/Maintain Database Standards and Architecture.

Applied best practices and performing Database health check procedures including DBCC checks and utilize DMVs/DMFs.

Created PowerShell Scripts to patch DLLs across various servers and also to automate database deployments (Dacpacs) using SSDT.

Involved in heavy PowerShell scripting to perform database true-ups, BCP and moving XML based data across servers.

Defining processes and ensuring that the processes are adhered to oversees and is responsible for successful completion of Installation, configuration and migration.

Recommend and Review Backup and Recovery Strategies and test plan for failure scenario and designed SQL Server Security (Server hardening, Auditing).

Implementing high Availability Features (Failover Clustering, Database Mirroring, Log Shipping and Replication).

Performed in Performance Tuning, Query Optimization, Client/Server Connectivity, Database Consistency Checks using DBCC Utilities

Written and executed complex T-SQL queries using enterprise manager for back end data validation testing.

Advance Database Performance tuning (Perfmon, SQL Profiler, Database Engine Tuning adviser etc) & Install, configure and Administering SSRS, SSIS.

Maintain and support developers for SSIS/DTS, SQL Analysis Services SSRS.

Ensure all database are backed up to meet the business requirement (SLA) RPO and RTO

Developed SQL codes using T-SQL queries, Stored-Procedures, functions, and Triggers

Conducted daily and weekly database health, SQL Servers configuration and security check

Performed in SQL Server Reporting Services (SSRS) and Integration Services (SSIS) to manage data warehouse environment.

Create database design, objects and metadata information for three different applications.

Create and schedule Autosys jobs to run the delta framework.

Performance tuning the SQL code to efficiently process all of the data.

Writing ETL's which will be scheduled on daily basis for loading the data.

Strong RDBMS concepts and experience in creating, maintaining and tuning Views, Stored Procedures User Defined Functions and System Functions using SQL Server, T-SQL.

Good experience in creating SQL Server database objects like tables, views, procedures, functions and triggers for a project.

Environment: MS SQL Server 2008, MS SQL Server 2005, MS SQL Server 2000, MS Access, IIS Server, SSIS, SSRS, SSAS, T-SQL, PowerShell ISE, Visual studio, Share point, Dell Power Edge 8450, VSS, Quest Spotlight, Lite speed, SQL Server Enterprise Edition 2008, Windows Enterprise Server 2008.

RxLogix Corporation, New Delhi, India November 2009-October 2011 Role: SQL Server Developer/DBA

Responsibilities:

Performed day to day activities of SQL data base administrator on SQL server 2008/2008R2 enterprise edition.

Team of six DBAs supporting client and in-house database systems (MSSQL Server) on various infrastructure projects improving service level agreements by reducing time to deliver database solutions to business.

Create database objects such as tables, views, stored procedures, Triggers and develop T-SQL procedures, query performance tunings.

Create functions to provide custom functionality as per the requirements.

Experience in creating, maintaining and tuning Views, Stored Procedures User Defined Functions and System Functions using SQL Server, T-SQL.

Created PowerShell Scripts to patch DLLs across various servers and also to automate database deployments (Dacpacs) using SSDT

Wrote SQL, T-SQL, Stored-Procedures and triggers. Assisted SQL developers to optimize SQL queries, Stored Procedures and Triggers

Worked as a developer in creating complex Stored Procedures, DTS packages, triggers, tables, and views, Developed complex T-SQL code for the application

Developed and coded applications in T-SQL. Debugged and fixed the bugs. Performed database and SQL tuning by using various tools and techniques, like Tuning Advisors

Create Users and assign permissions based on the level of database access the user would need.

Design database Backup and Restoration Strategy

Once created the database Backups, monitor those backups are being performed regularly. (SQL Server Agent)

Troubleshoot various problems that arise in a day-to-day work and fix the issues.

Monitoring and Performance Tuning; Physical Server Level, Database level (Database settings and options) and query tuning (Creating and maintaining those Indexes, not performing database shrinking, memory settings, monitoring CPU usage and Disk I/O activity etc)

Perform restores from production to other environments and Run jobs/create new jobs using SQL Server agent.

Performing re-building and re-organizing the indexes.

Run trace to identify slow running queries and analyze the same in tuning advisor.

Perform analysis on slow running queries with execution plan.

Developed stronger ties between customers and Infrastructure team resulting in collaborating and working together to effectively use IT for business.

Participated in quarterly meetings with Senior Management to discuss technical infrastructure and market recommendations assisting in the formation of the technology roadmap.

Installed, configured and maintained 2005, 2008R2 SQL Servers, virtual and standalone environments.

SQL server performance tuning, backup and recovery, replication, index maintenance, security, and troubleshooting.

Analyzed Query statements and Stored Procedures for tuning using Estimated Execution plan, Tuning Advisor.

Developed moderate stored procedures, views, user defined functions, indexes, and constraints.

Environment: Windows Enterprise Server 2008/2008R2, SQL Server Enterprise Edition 2008 Enterprise Manager, Query Analyzer, System Monitor/Performance Monitor, T-SQL, Event, Viewer, SQL Profiler, and DTS, Compaq P IV CPU with 1GB RAM, Software

EDUCATION:

Bachelor of Engineering, India

Contact this candidate