Mary Ndi Siri

• As a production L2 support,we are responsible for resolving incident tickets escalated from L1 support and handling critical incidents(Sev1,Sev2 high).
• Providing SQL Server implementation changes requested from application teams.
• Responsible for installing, configuring, and maintaining as per supported LOB applications.
• Writing and improving SQL Server T-SQL queries.
• Created necessary T-SQL scripts, stored procedures, tables, views, functions, triggers and indexes.
• Responsible for providing SQL Server problem resolution and 24x7 production support and server outages.
• Responsible for disaster recovery and high availability solutions and large scale database migrations from SQL server 2005 to SQL server 2008R2 and 2012.
• Created and migrated partially contained databases within AlwaysOn Availability Groups.
• Created automation of day to day operations, critical SQL server alerts and repetitive tasks.
• Monitored the health and performance of SQL, server instances and home grown applications using Extended Events, SQL server Profiler, PerfMon and other third party tools.
• Tested newly built servers for performance impact with DB load simulators.
• Setup and maintained Log Shipping between various environments.
• Development/Test/Production QA which included documentation of processes, creation of test scenarios and execution of tests, via T-SQL scripts, to ensure UI standards met the required specifications.
• Created necessary T-SQL scripts, stored procedures, tables, views, functions, triggers and indexes.
• Operated and oversaw database and log backups and restoration, planning backup strategies, and scheduling.
• Backed up master & system databases and restoring them when necessary.
• Optimized the Indexes, adding/deleting them when necessary for better performance.
• Verified backups and error logs on the servers and troubleshoot any failures or alert problems, and open trouble tickets if necessary to work with technicians from other departments.
• Responsible for Installing, configuring and maintaining SQL failover clustering for production environments.
• Worked with installation, configuration and creation of SSRS.
• Deciding whether clustering, log shipping, mirroring, replication, etc are the right fit to solve a business problem.
• On-call troubleshooting for SQL Server service outages.
• Responsible for securing SQL Server, user management, and taking care of permissions and roles.

Environment: Microsoft SQL Server 2014/2012/2008R2 Enterprise and Standard Editions, Windows 2012/2008R2, Clustering, Always On, Mirroring, replication, SQL Server Management Studio, SQL Profiler, Performance Monitor, SSIS, SSRS, Microsoft Visual Studio 2012, TOAD for MYSQL, Microsoft Office 2013, Mongo DB.

United Healthcare,serves key markets and geographic regions with a broad range of health benefit products and services for both consumers and benefit sponsors.

Responsibilities:

• Installed and configured SQLServer2008 R2/ SQLServer2008 with backup jobs, database mail and configuration options.
• Upgraded SQL Servers with latest service packs.
• Migrated SQL Server databases from SQL Server 2005 to SQL Server 2008 R2.
• Created, administered & maintained SQL Server Databases on Production, Test and Staging for various groups and ensured the availability of the database Servers.
• Configured and maintained transnational replication for flow of data from QA and Dev. Server to the replica servers.
• Monitored data activities like database status, logs, space utilization, locks and long transactions.
• Implemented SQL standards in writing stored procedures, Triggers, Views, SQL functions.
• Involved in resolving deadlock and blocking issues for concurrent users. · Worked with developers to optimize the code if required to minimize the duration and look if the indexes were used appropriately.
• Provided appropriate access to users except system databases owners. · Refreshed databases for pre or post data loads activities.
• Supported SQL server developers working on different projects with various requests.
• Converted and redesigned existing DTS packages to SSIS packages.
• Developed SSIS packages to import and export data from existing systems to upgraded system.
• Used database utility programs and 3rd party utilities to monitor database performance, such as Blocking, expensive queries, Memory utilization.

Environment: MS SQL Server 2008R2/2008/2005, T-SQL, Lite Speed, SQL Profiler, Log Shipping, Replication, Mirroring, Clustering, Windows 2003/2008 Server and ERWIN.

Orange & Rock land Utilities Inc. (O & R), a subsidiary of Consolidated Edison, Inc., is an electric and gas utility which along with its two utility subsidiaries serves approximately 750,000 customers spread across seven counties located in New York, northern New Jersey and northeastern Pennsylvania.

Responsibilities:

• As a L2 support,we worked on incident tickets escalated from L1 support team.
• Responsible for MS SQL Server 2005 and 2008 and database administration.
• 24x7 critical production support for hundred and ten SQL Servers out of which 75 were mission critical production support.
• Created database maintenance plans for SQL backups, optimization, and integrity check and t-log backups.
• Created checklists for proper/unattended install of SQL Server, applied service packs and security fix.
• Configured and maintained transactional and Snapshot replication for 3 environments.
• Worked with SQL Disaster Recovery processes and documented/revised those processes.
• Worked with capacity planning, database sizing and monitoring.
• Created databases, tables, indexes, stored procedures and triggers, alerts and maintained user permissions.
• Involved in creating DTS Packages to import and export operations in and out of SQL Servers.
• Applied monthly patches and hot fixes. Worked with application team to test the successful upgrades.
• Maintained Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules.

Environment: MS SQL Server 2008/2005, T-SQL, SQL Profiler, Log Shipping, Replication, Mirroring, Clustering, Windows 2003 Server.