Niraj M. Email and Phone Number
• 9+ years of experience with the 32-bit, 64-bit Microsoft SQL Server in Production, Pre-Production, Testing/Quality Assurance, Development in Clustered and Stand-alone Server Environments.• Experience in installing, configuring, and hardening MS SQL Server Azure/2016/2014/2012/2008R2/2008/2005/2000 and applying patches, hotfixes, and service packs.• Expertise in implementing Side-by-Side Migration and in-place Upgrade of MS SQL Server 2016/2014/2012/2008R2/2008/2005.• Started a project to consolidate servers and remove/migrate old and unused databases.• Experience in working with Windows Server 2012, 2008 R2, 2008, 2003.• Expertise in configuring, implementing, and monitoring different types of High Availability and Disaster Recovery including Replication, Log Shipping, Database Mirroring and Clustering.• Experience in implementing AlwaysOn Availability Groups in SQL Server 2016/2014/2012.• Hands on experience with Amazon AWS RDS instances.• Extensively worked on Amazon AWS EC2 windows instances and Amazon AWS S3.• Expertise in backup, restore the database manually and scheduling jobs and Maintenance Plans.• Worked extensively on Performance Tuning by analyzing index fragmentation, execution plans, and finding missing indexes. • Extensively used the native tools SQL Server Profiler, PerfMon, Activity Monitor, Index Tuning Wizard, Database Tuning Advisor, Log Viewer and Event Viewer for performance analysis.• Experience configuring and working in MS SQL Server 2012/2008 and MS SQL Server 2005 on VMware Environment. • Proficiency in troubleshooting SQL Server jobs. • Expert in creating database objects like Tables, Views, Indexes, Cluster Column-store Indexes, Stored Procedures, Cursors and Triggers using T-SQL.• Sound knowledge of RDBMS concepts including Normalization, Joins, Keys and Constraints.• Hands on experience in Configuring SMTP Server for Database Mail.• Handled multiple SQL Instances on clustered environment for projects built on SAN using RAID levels.• Rebuilding indexes with different fill factors and updating statistics. • Experience in creating SSIS packages using control and data flow elements.• Experience in extracting and transforming (ETL) data using SSIS, Import/Export, Bulk Insert and BCP. • Working knowledge of Analysis Services (SSAS) and Reporting services (SSRS).• Experience in Database design, Performance Analysis, Production Support for very large (VLDB) and Complex Databases.
Baylor Scott & White Health
View- Website:
- baylorhealth.com
- Company phone:
- 844-279-3627
-
Sql Database Administrator (Sql Dba)Baylor Scott & White Health Jul 2019 - PresentDallas, 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.
-
Sql Database Administrator (Sql Dba)Puget Sound Energy Mar 2018 - Jun 2019Bellevue, 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. -
Sql Database Administrator (Sql Dba)West Bend Mutual Insurance Oct 2014 - Mar 2018West 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. -
Database AdministratorPacific Source Health Plans Feb 2014 - Sep 2014• 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.
Frequently Asked Questions about Niraj M.
What company does Niraj M. work for?
Niraj M. works for Baylor Scott & White Health
What is Niraj M.'s role at the current company?
Niraj M.'s current role is SQL Database Administrator (SQL DBA) at Baylor Scott & White HealthDirect Contact - 919.341.2663.
Who are Niraj M.'s colleagues?
Niraj M.'s colleagues are Dwayne Cove, Candy Velazquez, Tiffany Terral, Susan Jones, Liz Njokie, Mounir Fawzi Khalil, Md, F.a.b.p.m.r., Lillian Cavalcante.
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial