PROFESSIONAL SUMMARY:

• 8 years of Core Database Administration and production support experience working on MS SQL Production, Development and Testing in Clustered and Stand - alone Server Environments.
• Expertise in Database Administration activities that include Installation, Configuration, Backup & Recovery, Database Security, Database designing and Query optimization.
• Experience in SQL Database Administration, System Analysis and Design, Development & Support of MS SQL Server2000, 2005, 2008, 2008r2, 2012, 2014, 2016, 2017 in Production, Development & VMware Environments.
• Worked on SQL Server AlwaysOn High Availability feature and has a firm understanding of Contained Databases and Availability groups (HADR) of SQL Server.
• Experience in implementing many types of High availability and Disaster Recovery solutions like Clustering, Database Mirroring, Cold Standby, Warm Standby, Log Shipping, and Replication.
• Experience in upgrading SQL Server software to new versions and applying Service packs and hot fixes.
• Expert in Performance Tuning by Index Defragmentation, optimizing execution plans, proper usage of indexes.
• Experience in troubleshooting and problem solving of MS SQL database Servers.
• Good experience in resolving SQL Server blocking and Dead Lock Issues.
• Experience in database design that involves creating normalized databases, user authentication, query tuning, assigning proper indexes, creating stored procedures, functions, triggers and data types.
• Good at Data availability solutions like Online Restore, Online index operation, Database Snapshot and Fast Recovery.
• Experience working with Production (24 x 7) and Development environments.
• Created Database users, controlling access to SQL Server and making sure right people get access to right data and looking after security issues.
• Performed physical database analysis and feasibility requirements. This involves performance, security, maintenance and recovery requirements.
• SQL Production database Support Engineer.
• Customer support.
• Experience in creating Packages, Jobs, sending alerts using SQL Mail and custom extended procedures.
• Intensive experience in monitoring and tuning SQL Server database performance using SQL Profiler, DMV's, Index Tuning Wizard and Windows Performance Monitor.
• Experience in Creating and Maintaining Database Maintenance Plans for the new server boxes.
• In depth hands on experience on Transactional Replication and database mirroring for Very Large Databases (VLDBs) and highly transactional systems.
• Flexible, Enthusiastic and project oriented team player with excellent communication skills and analytical skills to develop creative solution for challenging client needs.

WORK EXPERIENCE:

Senior SQL Server Database Administrator

Confidential, Dallas

Responsibilities:

• Monitor performance of database systems resources and query throughput
• Optimize SQL Code as necessary Monitor and maintain database storage resources
• Monitor and maintain database maintenance plans for backups, index rebuild/defragment, and database statistics SQL Server Installation, Upgrades, Migrations and Configuration Install database software service packs and cumulative updates as necessary.
• Maintain database documentation as required.
• Maintain and administer database security access.
• Perform database Ad-hoc backups and restores.
• Trouble shoot and resolve database connectivity issues.
• Follow Change Management processes to implement database configuration changes.
• Follow Problem Management processes to troubleshoot and resolve recurring issues
• Proactively monitor and respond to MSSQL database Alerts.
• On-call requirements to ensure 24 x 7 support of database operations
• Configure and maintain Always On Availability Groups, Failover Clustering
• SQL Production database Support.
• Customer support.

Principal Database Administrator

Confidential

Responsibilities:

• Administers, manages, and monitors all databases in development and test environments.
• Continuously monitors and manages database backup and recovery routines for all databases in development and test environments.
• Develops and maintains T-SQL script deployment packages to deploy all database structure, T-SQL code, and static data changes from development to test database environments. Coordinates with production DBAs to ensure that database upgrades are executed completely and correctly in production environment.
• Creates, enforces, and manages database access control mechanisms, such as users, groups, roles, permissions, etc. in development and test environments.
• Assists application developers and analysts in design of new database schema objects, such as tables and views.
• Continuously monitors database query/write performance and creates and maintains appropriate indexes.
• Continuously monitors execution of SQL Server Agent jobs to perform standard database administration tasks such as database statistics and index rebuilding, deadlock detection, table fragmentation detection, etc.
• Develops and maintains T-SQL stored procedures, functions, triggers, constraints, and other objects to enforce data integrity and application business rules.
• Works closely with application developers in the development, debugging, and performance tuning of T-SQL stored procedures and functions.
• Manages all T-SQL stored procedures, functions, triggers, and other objects.
• Develops, maintains, and executes custom data conversion routines to import, validate, and load customer data into databases in test and production environments using technologies including, but not limited to, SSIS packages and custom T-SQL stored procedures.
• Develops processes using T-SQL scripts and other technologies to move data between development databases, as necessary.
• On Call Rotation

Senior Database Administrator

Confidential

Responsibilities:

• Maintain database performance by identifying and resolving production and application development problems.
• Manage security on SQL Server instances.
• Create and maintain SSRS reports
• Provide production level support concurrently with developing in test environments
• Database software patching and day-to-day management
• Manage SQL installations configured on Microsoft Clustering platform
• Configure new backups of databases using native SQL backups, lightspeed and DD boost
• Assist with data backup and recovery
• Assist with documenting and maintaining the standard operating procedures for DR

SQL Server Database Administrator

Confidential

Responsibilities:

• SQL Server Installation, Upgrades, Migrations and Configuration
• Install database software service packs and cumulative updates as necessary
• Follow Change Management processes to implement database configuration changes.
• Administer and maintain database security access
• Trouble shoot and resolve database issues
• The administration, backup, integrity and security of various SQL servers and databases
• Perform database Ad-hoc backups and restores for both ad-hoc requests and validating database integrity
• Continually assess, improve, and optimize database environment.
• Proactively monitor and respond to MSSQL database Alerts.
• Database maintenance plans for index rebuild/defragment, and database statistics.

Information Systems Auditor

Confidential

Responsibilities:

• Evaluate risk, document processes and systems in flowchart and narrative form and design audit programs.
• Draft written reports and audit findings deliverables and present them to management.
• Suggest enhancements in controls, policies and procedures.
• Demonstrate project management skills; manage audits to meet target dates within budgeted hours.
• Manage multiple projects and communicate obstacles and status to Audit Services management.
• Manage technology governance methodologies and frameworks.
• Assess technology risk and develop audit and advisory plans.
• Audit to measure control requirements compliance.
• Oversee and report status of audit remediation activities.
• Handle completion of corrective actions.
• Innovate control automation techniques to minimize compliance cost.
• Guide on emerging operational, legal and regulatory compliance matters.

Senior Business Analyst

Confidential

Responsibilities:

• Lead the annual planning process for the Organization, including income statement, balance sheet and cash flows.
• Analyze historical performance and industrial trends to set up financial targets for the organization.
• Manage monthly forecast, consolidate and present forecast to management to facilitate executive-level business decisions.
• Develop and maintain financial models/tools for planning/forecast and analysis, and roll out the models/tools.
• Coordinate monthly financial reviews to analyze financial results, review variances vs. plan and develop action plans to meet financial targets.
• Assist management in preparing presentations to the Executive Committee for quarterly meetings, the annual plan meeting, and other executive events.
• Perform in-depth analysis to identify issues and opportunities; recommend strategies and solutions to increase revenue, reduce cost, and improve profitability.
• Update and maintain a Balanced Scorecard reporting system, deliver monthly balanced scorecards for business performance tracking and benchmarking.
• Use NPV, IRR, ROI and other financial techniques to analyze business initiatives, including but not limited to capital investment, variable contribution, pricing, and product launches.

Project Manager

Confidential

Responsibilities:

• Manage project costs and projections.
• Manage job site supervisory personnel
• Plan and schedule projects
• Contract negotiation and administration
• Negotiate and purchase materials
• Drive job site safety and establish job site safety expectations
• Oversee labour projections
• Complete daily and periodic report updates

Business Analyst

Confidential

Responsibilities:

• Assist Management, Site Managers, and Project Managers in developing project proposals.
• Develop effective Financial Analysis models and monitor monthly receivables to track results.
• Create, edit and manage recurring weekly, monthly, and quarterly reports.
• Review all business and technical requirements, design, and testing information to ensure quality output that meets stated business needs.
• Identify and escalate risks that could impact ability to deliver results on time and on budget.