Sql Server Database Administrator and Developer

Kamalpreet Kaur

Morris Plains, NJ ***** C: 908-***-****

E-mail: ************@*****.*** US Citizen

Summary

A reliable Microsoft certified IT professional with 8+ years of experience in Database Administration, software development life cycle, business requirement analysis, design, programming, database design, data warehousing and business intelligence concepts, star schema and snow flake schema methodologies.

Hands on experience in Installing, Configuring and Deploying MS SQL Server 2019, 2016, 2014, 2012, 2008 R2/2008/2005 with Business Intelligence in SQL Server Integration Services, SQL Server Analysis Services and SQL Server Reporting Services.

Cloud/Azure experience includes Azure Services, PaaS, IaaS, and Migrated from premises databases and Legacy databases to Azure, deployed products on Azure, Setup development and test environment on Azure.

Strong in Performance Tuning, Query Optimization, Automation, Trouble Shooting, Security, High Availability, ETL, Business Intelligence, Disaster Recovery, Replication, Version Upgrades/Database migration, Capacity Planning and Database Design.

Hands on experience in implementing Database backup’s strategies for Critical Application to define the Full, Differential and Transaction log backup’s policies.

Experience working with Windows Data center Cluster with multiple instances.

Expertise in writing T-SQL Queries, subqueries and joins for generating Stored Procedures, Triggers, User-defined Functions, Views and Cursors.

Experience in importing/exporting data between difference sources like Oracle/Access/Excel etc. using SSIS/DTS utility.

Major strengths include strong leadership, hardworking, ability to work under pressure, excellent team player, initiative and Adaptable, self-motivated, Mentor and on time delivery of projects and problem solving and ability to quickly grasp and master new concepts and technologies.

Knowledge in Data Science, Machine Learning and programming languages SQL, JavaScript, Python and R.

Knowledge on SCRUM/AGILE development methodologies.

Key Skills

MS SQL Server (2019- 2000), SSAS, SSIS, SSRS, High Availability (HA), Log shipping, Database Mirroring, Always On, Replication, Disaster Recovery (DR), Linked servers, Maintenance Plan and Agent Jobs, Alerts, PL/SQL, T-SQL, Power BI, Report Builder, MS Visual Studio, Microsoft Dynamics, Time Extender. DevOps, Idera, Spotlight, FogLight, Snap Manager, My Services, Service Now, HP Support Center, solarwinds, Idera

Education

M.Sc. (Information Technology)

Bachelor of Computer

Applications (BCA)

Microsoft Certified Solution Associate

Experience

Tifanny & Co, Parsippany NJ – Senior Engineer.

Feb 2020 – Aug 2022

Tiffany & Co. is an American luxury jewelry and specialty design house headquartered on Fifth Avenue in Manhattan. Tiffany is known for its luxury goods, particularly its sterling silver and diamond jewelry.

Responsibilities:

Involved in building high-standard database solutions to meet stability, reliability and performance metrics.

Worked as SME for FogLight, POS, General Ledger, Peoplesoft applications and Report server databases.

As a FogLight SME, worked as primary contact for vendor to plan system requirements for database and application servers and performed various tasks such as -

oInstall SQL Servers on database servers.

oSet up and configure agents on database servers for data collection.

oSet up and customize alerts based on performance thresholds or specific events.

oGenerate reports to track performance trends and system health.

oConfigure notification mechanisms to alert the DBA team of critical issues.

oAnalyze historical performance data to forecast future resource requirements.

oProvide training to other team members on Foglight usage and best practices.

oCollaborate with other IT teams and departments to resolve cross-functional issues.

Facilitate data integration between the General Ledger System and the other financial applications with SQL Replication. Performed Table Partitioning by year for GLMart database.

Worked on configuration of report server and report manager scheduling, give permissions to different level of users in SQL Server Reporting Services (SSRS).

Set up and controlled database roles and access levels for each database segment and Assisted in converting SQL Security individual accounts to Active Directory Security groups to protect important data.

Developed and maintained technical and functional documentation for all applications databases, processes, and jobs, including flowcharts and data models.

Prepared the Run plans on lower environments to migrate/upgrade/downgrade the SQL Server instances.

Provide proactive problem management to identify RCA to provide permanent resolutions.

Worked with windows team to reconnect computer accounts to the domain, enabled and deleted computer accounts, moved to correct OU and supported users network accounts through Active Directory.

Installed and configured SQL Server 2012, 2016, 2019 on standalone or AlwaysOn Failover Clusters with Availability Groups along with ODBC drivers and oracle 11g client on newly installed SQL Servers for data push/pull across systems as required.

Worked on creating and maintaining Azure SQL Databases (PAAS) on managed instance and Azure Virtual Machines (IAAS).

Worked on SQL Server 2016 migration from SQL Server 2008R2/2012, performing integrity checks and Consolidated client footprint by planned unused databases and moving from physical server to virtual servers.

Developed various complex T-SQL, PowerShell scripts for various DBA related tasks.

Researched, composed emails, and scheduled Teams meetings addressed to managers and Directors to determine database application owners for unused databases and to plan down time for multiple applications on shared instances.

Worked closely with capacity planning team to set and adjust the memory-monitoring standards for SQL Servers. Led the project to reduce CPU nodes on shared SQL Database servers for cost effective. Optimize configurations for memory, CPU, and storage to improve overall system efficiency.

Tracking recurring issues and providing solution/fixes. Identifying and automating frequently performed activities at work.

Managed service account passwords in safe.

Worked as CAB member to view, evaluate, and approve or reject the change requests.

Mentored newly hired employees, offering insight into job duties and company policies for easier transition to job position.

Provide supervisory oversight and work with DBA Managed services partner on priority support issues.

Managed workload independently but collaborated with colleagues to complete larger scale tasks in distributed team environment.

Used third party tools like Rubrik, Netbackup, ServiceNow, citrix, DDBoost, CDC.

E-Risk Services/ Nationwide, Flanders NJ – Database Developer.

Oct 2019 – Feb 2020

E-Risk Services, LLC is a managing general insurance agency. The Company provides management liability insurance products and services for privately held organizations.

Responsibilities:

Responsible for performing T-SQL tuning and optimizing store procedures which take longer time in execution.

Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), and SQL Server Integration Services SSIS.

Created PowerShell scripts to download data from external sources as flat files.

Designed SSIS Packages using FTP Task to transfer data from flat files to SQL Server using Business Intelligence Development Studio.

Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, script task and send Mail task etc.

Analyzed and performed Data mapping which involved identifying the source data fields, identifying target entities and their lookup table ids and translation rules.

Thorlabs, Newtown NJ - Database Administrator/Report Developer.

Oct 2016 – Oct 2019

Thorlabs specializes in the building blocks for laser and fiber optic systems. They are pioneer, manufacture & distributors of their products worldwide. They have internal systems to support call center, sales, CRM.

Responsibilities:

Perform day to day activities including monitoring, creating maintenance plans, SQL Agent Jobs, backup and restore, database refresh, implement SQL Server security and object permissions, maintaining database authentication modes, creation of users, configuring permissions and ensure that all production databases are running efficiently 24/7

Performing regular server health checks before starting the business hours.

Installed SQL Server 2016 software in stand-alone and clustered environment. Coordinate and install all releases, upgrades, and install all corresponding software’s.

Automating Database refreshes on SQL Server instance.

Maintain high performance environment using Performance tuning, query optimization, index tuning. Review and deal with index fragmentation, CPU Bottleneck, I/O Bottleneck, DBCC checks. Optimization of Query, Update Statistics, Error and Event Handling. Bring down processing times from minutes to seconds using DMVs and DMFs and SQL Profiler. Rebuilding Indexes and Tables as part of Performance Tuning exercise.

Configured and monitored peer to peer & transactional replication & Always on Availability Groups. Provide solution to resolve replication conflicts and failures.

Worked on SQL Server 2016 migration from SQL Server 2008R2/2012, performing integrity checks and minimizing down time.

Deploy the code changes from development to test and production environment.

Installed and configured SSRS and Power BI Report Server. Developed and deployed SSRS reports and Power BI dashboards and configured report subscriptions. Created and optimized diverse SQL queries, views, stored procedures and functions to build consistent reports.

Formatted dashboards, multiple chart types, trends and KPIs with Power BI to support analyses. Utilized Power BI to keep dashboards and reports up to-date with on premise data sources to display information required by different departments and upper-level management.

Created data warehouse (star and snowflake schema), fact table, cubes, dimensions, measures using SSAS. along with reporting services with company-wide, secure access. Add dimensions and facts on periodic basis. Provided training to the managers in using the system, generating reports from excel using cube.

Worked with other Technical Teams like Application Admin team, Server team and Network team to solve Performance and/or connectivity issues.

Prioritizes assigned tasks and ensures these are completed on or before the scheduled date of completion.

Provide 24x7 On-Support on weekly rotation basis.

Used third party tools like Snap Manager for backups, Quest Spotlight for monitoring, TimeXtender Scheduler Service to run scheduled execution packages for cubes, Spiceworks for user requests and MS Dynamics Axapta.

NYPD/ FDNY, New York - Database Administrator/Developer

Jan 2016 – Oct 2016

NYPD/FDNY uses Intergraph public safety & security software to handle 911 calls and dispatch center tasks & perform various activities based on the type of request.

Responsibilities:

Maintaining the database systems includes but is not limited to ensuring successful backups, resolving system issues, monitoring success and failure of automated jobs, monitor system availability, monitor database growth, updating system documentation etc.

Configured and monitored and maintained Database Mirroring, Log Shipping and Transactional Replication for Disaster Recovery.

Configured SQL Transactional Replication across the network for FDNY.

Created periodic Daily, weekly, monthly or annual reports using Report builder and deployed on Report Server (SSRS).

Created and modified stored procedures, Functions, Indexes, Triggers, formulated basic coding and scripting.

Worked on DDL/DML Triggers to facilitate efficient data manipulation and data consistency to support the existing application.

Perform regression testing to check the working functionality of CAD application.

The Boeing Company, Michigan – Database Administrator

July 2015 – Dec 2015

Boeing is the world's largest aerospace company and leading manufacturer of commercial jetliners and defense, space and security systems.

Responsibilities:

Installed, maintained and upgraded Stand alone and Cluster SQL Servers.

Deployed Patches and Hot Fixes in development, test and production.

Day to day activities includes database creation/drop, database refresh, run scripts, creating Agent jobs, maintain Logins and permissions.

Handled Migration from Development to Test and Production Environment and from one version to another version i.e. SQL Server 2005 to SQL Server 2012.

Monitoring constant Database growth, Transaction Logs growth and shrinking the files to release the unused space.

Running update statistics, index rebuild, dbcc check dB on periodic/scheduled basis.

Used third party tool to deploy patches in bulk, ServiceNow and My Services for user requests.

Contact this candidate