Niraj M. Email & Phone Number

Dallas, Texas, Us

• Worked on migrating SQL Server from one data center to another data center.• Migrated SQL Servers from on-prem to Azure Cloud.• Installed and managed third party databases for new applications.• Performed side by side upgrade and in-place upgrade from SQL Server 2008R2 to SQL Server 2016/2014.• Involved in implementation of AlwaysOn Availability Group as a High Availability solution.• Administrated SQL Server 2016/2014/2012 on production and non-production servers.• Migrated individual user access to AD group and managed security.• Involved in Capacity planning for different servers.• Involved in reviewing, planning, testing, and installing database security patches and service packs.• Created SSIS packages for maintenance of databases.• Performed day-to-day activities/tickets including full, differential and log backups, database restores/refreshes and proactive monitoring of SQL server health. • Worked on point in time recovery and point of failure recovery.• Created databases and database objects including tables, views and indexes using T-SQL as per naming standards.• Deployed schema changes to QA, PreProd and Prod servers as per change management process.• Used third party tools including Foglight, LiteSpeed, Spotlight.• 24/7 dedicated on-call support on team rotation basis and supported monthly and weekly production releases outside business hours.

Bellevue, Wa, Us

• Extensively worked on migrating SQL Server from old data center to new data centers.• Migrated standalone SQL Server to AlwaysOn 3 node and 4 node architecture.• Worked on Amazon AWS Elastic Compute Cloud (EC2) and Simple Storage Service (S3).• Migrated on premise databases to AWS EC2 and AWS RDS instances.• Installed and managed third party databases for new applications.• Installed Power BI in Production and non-Production environment. • Administrated SQL Server 2016/2014/2012 on production and non-production servers.• Worked on setting up the SQL Server Configuration to resolve various resource allocation and memory issues for SQL Server databases and to setup min/max memory options. • Performed security management by creating Logins and Users with minimum required permissions.• Involved in Capacity planning for different servers.• Implemented and maintained Database Mirroring and Transactional Replication as a Disaster Recovery solutions.• Involved in reviewing, planning, testing and installing database security patches and service packs.• Deployed and migrated various SSRS reports in production environment. • Created SSIS packages for maintenance of databases.• Performed day-to-day activities/tickets including full, differential and log backups, database restores/refreshes and proactive monitoring of SQL server health. • Worked on point in time recovery and point of failure recovery.• Created databases and database objects including tables, views and indexes/columnstore indexes using T-SQL as per naming standards.• Deployed schema changes to QA, PreProd and Prod servers as per change management process.• Installed SSL certificates on Production and non-Production SQL servers.• 24/7 dedicated on-call support on team rotation basis and supported monthly and weekly production releases outside business hours.• Managed more than 200 SQL servers with 3000 plus databases of various sizes and up to 1TB.

West Bend, Wi, Us

• Worked on projects to provide DBA support for building SQL Server 2016/2014/2012 for new applications.• Worked with vendors to install and manage third party databases for new applications.• Managed and administrated SQL Server 2016/2014/2012/2008R2 on production and non-production servers.• Performed side by side upgrade from SQL Server 2005/2008 to SQL Server 2016/2014/2012.• Started a project to consolidate servers and remove/migrate old and unused databases.• Extensively worked on hardening of SQL servers as per CIS benchmarks.• Participated in a Business Continuity Process (BCP) to check the Disaster recovery solution.• Worked on setting up the SQL Server Configuration to resolve various resource allocation and memory issues for SQL Server databases and to setup min/max memory, max DOP server options. • Created Logins and Users with appropriate permissions and performed security management.• Extensively implemented Partitioning on large tables to improve the performance with Data Warehouse team.• Involved in Capacity planning for different servers.• Implemented and maintained Database Mirroring and Transactional Replication as a Disaster Recovery solutions.• Involved in implementation of AlwaysOn Availability Group as a High Availability solution on SQL Server 2012.• Involved in reviewing, planning, testing and installing database security patches and service packs.• Deployed various SSRS reports and Cubes using SSAS.• Created SSIS packages for maintenance of databases and as an ETL solution.• Performed day-to-day activities/tickets including full, differential and log backups, database restores/refreshes and proactive monitoring of SQL server health. • Diagnosed and fixed SQL server agent job errors.

• Migrated production and non-production SQL Server 2008 R2 databases to SQL Server 2012 databases side by side.• Managed and administrated SQL Server 2012/2008R2 in Prod, QA and Dev environments. • Daily QA and Prod deployments of SQL objects like stored procedure, functions and tables using Team Foundation Server (TFS).• Created Logins and Users with appropriate permissions and performed security management.• Created user-defined roles and assigned to users.• Proactively monitored Event Viewer, SQL Error logs and Log File Viewer for software and hardware related errors.• Performed day-to-day activities including full, differential and log backups (scheduled backups for databases and transaction logs) to disks and restored the databases.• Performed database refreshes. • Health checking of prod and non-prod servers.• Monitored Replication setup on databases.• Created SSIS package for CDC (Change Data Capture) as a proof of concept. • Created entities, views using Master Data Service (MDS).• Developed database size tracking system and created monthly reports using PowerView and PowerPivot.• Extensively worked on extracting, transforming and loading (ETL) of data to SQL Server using Informatica tools (PowerCenter Designer, Workflow manager, Workflow monitor and Repository)• Developed and deployed SSIS Packages to create logins and users. • Applied patches and service packs to keep the servers at current patch level.