SUMMARY:

• Over 10+ years of IT experience in Analysis, Development and Support for various domains in ALL versions of MS SQL Server.
• 10 years of database administration experience by managing various SQL databases in many different environments of different versions (SQL Server 2014/2012/2008 R2/2005).
• 7 years experienced in Confidential ’s Enterprise Commerce Volume Licensing Applications
• 4 years of MSBI experience in troubleshooting SSIS Packages and SSRS reports of different versions (SQL Server 2012/2008 R2)
• Expertise in SQL development activities like writing queries, creating packages and reports etc.
• Extensively worked on SQL and IIS application Support in QA, UAT and Production environments.
• Expertise in application Support and managing pre - prod/production environments based on defined SLA.
• Expertise in SQL Azure Admin. Migrated SQL DBs from on-prem to Windows/SQL Azure environment.
• Proficient in dealing with Windows Azure - Compute, Networking, Storage, Security, Identity, Developer Services, Monitoring and Management.
• Expertise in Virtual Networks, Virtual Machines, Cloud Services, Express Route, Traffic Manager, VPN, Load Balancing, Auto Scaling.
• Experience in Provisioning, Configuring and Publishing Web and Worker Roles in Azure PAAS.
• Experienced in developing tools & automation for reducing manual efforts, pro-active monitoring using scripting technologies as per identified requirements
• Experienced in Installation, Patching, Configuration and Administration of SQL Server 2012, 2008 R2 and 2005 and VM Guests.
• Experienced in Datacenter Migration; Experienced in managing SQL Shared Instances.
• Experienced in Downgrades, Upgrades & Migrations of legacy servers to the latest SQL Versions.
• Designed and implemented enterprise wide Backup\Recovery strategies over Data Domain Appliance.
• Experienced in configuring High Availability solutions like Always On, Database Mirroring, Log shipping and clustering.
• Experienced in different types of Replication Models like Snapshot, Merge and Transactional.
• Expertise in Performance Tuning and Query Optimization using native tools like Database Engine Tuning Advisor, Query analyzer.
• Experienced in troubleshooting performance issues using Database Management Views (DMV’s), extended events, SQL Profiler, PerfMon and 3rdparty tools like AppInsight, Performance dashboard.
• Excellent Developer skills in developing Stored Procedures, Indexed Views, User Defined Functions, Triggers.
• 24X7 on call support for Production databases, Troubleshooting and problem Solving.
• Experienced in managing resources by assigning various projects and have successful track record of completing 95% of the projects on time. Experienced towards ITIL life cycle process.
• Good interpersonal Skills, Result Oriented, hardworking with quest and zeal to learn new technologies.
• Strong multi-tasking aptitude to manage multiple issues/projects in a fast-paced environment
• Excellent communicator with perseverance, creativity and reasoning ability to analyze complex cases and effectively handle emerging process problems, experienced in managing Onsite and Offshore resources
• Commendable leadership skills coupled with effective interpersonal techniques that facilitate interaction with people of diverse cultural background across the organizational ladder and manage change with ease.
• Versatile and multi-skilled with ability to manage multiple responsibilities simultaneously; achieve defined goals, objectives and milestones
• Proficiency in Service Management Framework - Incident, Change, Release, Problem Managements. SLA maintenance, Key Performance Area measurements.
• Highly experienced on supporting mission critical and multi billion revenue enabling applications from Confidential as a L3 Production support specialist/service engineer

TECHNICAL SKILLS:

T: SQL

RDBMS: SQL Server 2014/2012/ 2008 R2/2005/2000

Internet Technologies: Internet information services, Azure IAAS, PAAS

Operating Systems: Windows Server 2012/2008/2003/2000 , Windows 7/Vista/XP.

SQL Server Tools: SQL Profiler, Import\Export Wizard, SQL Server Performance Dashboard

Monitoring Tools: AppInsight, Kusto, SCOM, Fidler

Development Tools: Power shell Scripting

High Availability: Always On, Log Shipping, Replication, DB Mirroring and Clustering

PROFESSIONAL EXPERIENCE:

Confidential, New Castle, DE

Sr. SQL DBA

Responsibilities:

• Test programs or databases, correct errors and make necessary modifications.
• Handling Team Foundation Server administration activities which consists of SQL Database
• Supporting the SQL batch processing performed at the Database level.
• Modify existing databases and database management systems or direct programmers and analysts to make changes.
• Plan, coordinate and implement security measures to safeguard information in computer files against accidental or unauthorized damage, modification or disclosure.
• Work as part of a Dev team to coordinate database development and determine project scope and limitations.
• Write and code logical and physical database descriptions and specify identifiers of database to management system or direct others in coding descriptions.
• Train users and answer questions, Manage users and user access levels for each segment of database.
• Approve, schedule, plan, and supervise the installation and testing of new products and improvements to computer systems such as the installation of new databases.
• Review project requests describing database user needs to estimate time and cost required to accomplish project.
• Develop standards and guidelines to guide the use and acquisition of software and to protect vulnerable information.
• Providing production support - data administration activities for production servers, monitoring day-today processes, timely fix of the production problems encountered, data fixes and troubleshoot the issues for the business users and business analyst.
• Discuss business solutions with State Business Analysts, resolve existing problems and improve the application stability.
• Coordinate with business clients, support the application and implement the process as per specifications provided.
• Requirements gathering and analysis, time estimates, preparing design documentation, design reviews, development, testing and deployment of application enhancements, project planning.
• Answering the technical queries, driving the product initiatives and metric collection and analysis.
• Reviewing of work products and deploying the application in the test environment and initiate the process of user acceptance testing. It includes fixing of bugs and fixing technical errors that may come up during this phase.
• Supporting the system components during system testing, integration testing and during promotion of these components to production environment.
• Regular interaction with the Conduent Manager, Database administrators, Network and System Administrators, Application Users - all belonging to different departments and divisions of Delaware State to ensure the smooth running of the applications.
• Provide in-depth technical incident investigation, diagnosis, and resolution expertise resolves.
• Interface with Third party vendors for Incident resolutions.
• Detection of possible problems Database administration of complex issues
• SQL Database performance debugging and tuning

Environment: MS SQL Server 2016, SSIS, Windows server 2016.

Confidential, Redmond, WA

Sr. SQL DBA

Responsibilities:

• Bringing up efficiency/value add by implementing service improvements, excelling operations and creating efficiency with technical solutions.
• Build & Migration of existing systems to Cloud (Windows Azure) as per business need & technology upgradation without interrupting service availability
• Reporting project status service availability, infrastructure availability, major incidents, ticketing trend, new projects & customer experience weekly, Monthly & Quarterly to all stake holders
• Validate service performance across work streams and publish Service Dashboard on a periodic basis indicating project health with tracker and measure/report performance
• Major Incidents, Crisis handling and drive till resolution with problem management analysis for a permanent solution to improve customer service & support
• Collaborating with Engineering\Release management team to develop process changes in response to identified issues in the production environment & business need
• Review status with the Project teams and SMEs in constantly exploring further process improvements, automation and cost optimization for the customer
• Understand the customer’s business priorities, pain points & processes and analyze which of those can be addressed through technology solutions.
• Responsible for maintaining the operational health of the business with respect to service engineering, delivery metrics and customer satisfaction
• Driving KB updates and flagging new updates to stakeholders on process improvements & new projects

Environment: MS SQL Server 2012, SSIS, Azure IAAS, PASS, Windows server 2012.

Confidential

SQL DBA

Responsibilities:

• Identifying automation needs and work with the appropriate teams to create and improve the existing tools for automation for self-healing
• Engage Stakeholders on a weekly call to discuss status reports and give a brief overview on new projects along with reporting of completed projects for that week
• Conduct periodic review of operations and collect feedback from Client & Internal Management on operational efficiency and alignment with customer’s strategic roadmap
• Focus on complex issues related to operational aspects that cannot be resolved by L1 or L2
• Provide in-depth technical incident investigation, diagnosis, and resolution expertise resolves.
• Provide KT to Line 3 and training service Desk; Interface with Third party vendors for Incident resolutions
• Detection and notification of possible problems and making sure
• BVT for releases (monthly, quarterly) and maintenance activities (Security Patching etc.,)
• Responsible for overseeing the maximum system uptime; Working on user issues logged in Service Now tool
• Database management and Application support; Mitigate the bugs and repeated issues.
• Resetting Service accounts passwords when due for renewal
• Notifying the application users using RM Planner to users when the app is not available to end users
• Creating new Knowledge base articles for the applications that we support in Primus.
• SSL certificate Renewals; Trouble shooting Firewall Issues.
• Monitoring of Job Failures, System Alerts, App insights alerts, SCOM Alerts, Sonar Alerts, Alert Investigation, Alert Resolution

Environment: MS SQL Server 2012, SSIS, Azure, Windows server 2012.

Confidential India

SQL DBA

Responsibilities:

• Monthly Patch management of nearly 100 Confidential data center servers.
• Maintenance of 50+ Window 2003/2008 Servers with IIS and SQL 2005/2008.
• Monitoring MOM/ SCOM Console for any server issues and resolving them.
• Investigating performance related issues. Drive Space Monitoring of all the servers (WEB & SQL)
• Migrating Outdated servers to the new Virtual Machines/ Hyper Vs.
• IIS - Setup, App pools, Site Creation, SMTP and Administration.
• Managing SQL Jobs and Backups; monitoring the service down alerts
• Evaluating existing KB’s and modifying the content; creating new KBs if required.
• Notifying the application users when there is maintenance on the servers.
• Troubleshooting failed indexing & archiving requests of MS clients for their builds.
• Performing regular Backups and restore operations whenever required.
• Monitoring Database Mirroring with High Availability Mode in MS SQL.
• Monitoring Log shipping and troubleshooting of errors. Replication; monitoring clustered nodes.
• Check the Performance Tuning, Query Optimization, and Database. Administrator tasks like managing users, roles, granting permissions. Scheduling jobs in SQL server.
• CR creations in ITSM for any changes on the Production servers.

Environment: MS SQL Server 2008 R2, Windows server 2008

Confidential

Assistant Manager IT and Server Administration

Responsibilities:

• Diary Watch Cards (Self Audit Checklist), Patch/Anti-Virus Management, Incident Management - REACT IT Security Reviews, Risk Assessment, IT Security Policies/Procedures, Implementation of IT Audit Recommendations, Standard Operating Procedures, Operational Reviews with ICD, Change Management, Migrations - ITUR, IT Fraud and Theft Investigation; Dealing with rapid and on-going changes in technology resulting in new security vulnerabilities; Implementation of enterprise-wide disaster recovery/ business continuity plans including Manage semi-annual tests of the DR/BRC plans, evaluate effectiveness, and modify plans as required.Maintains the integrity of systems and the timely execution of backup procedures
• Maintenance of 50 servers, which includes Domain Controllers, File Servers, DNS, DHCP, Blue Coat Proxy, Lotus Domino Mail Servers, 14 TB SAN with LUNs configuration, HSBC Application Server, etc.
• E-Fax Application server administration; Monitor and maintain servers and server daily check lists.
• Identify and immediately escalate issues that are beyond my level of support.
• Managing Replication between different sites and scheduling Replications in Lotus Domino.
• Monitoring Event Logs, Services Status, and Security patches updating.
• Monitoring Server Performance by using Performance Counters
• Managing Print, DC, File, DNS, DHCP, Blue Coat Proxy, Lotus Domino Servers, 14 TB SAN.
• Protecting the System and data from Viruses by installing Antivirus Software (ex: MacAfee) Monitoring Antivirus updates on the servers. Backup and Restorations using VERITAS Net Backup

Environment: MS SQL Server 2005/2008, windows Server 2008, Lotus Domino server, Windows XP, 2000, NT