SUMMARY:

A well - versed IT professional with over a decade of experience including my 8+ years’ in MS-SQL DBA and Windows Server with vast knowledge in SQL Server 2008 R2, 2008. An experienced professional who has worked in retail, manufacturing and high-tech hybrid environments managing more than 5,000 MS SQL instances, 7,000 databases, VLD, Always On/Traditional clustered, replicated and mirrored (2008, 2012, 2014, 2016, 2017 and 2019 MS SQL), environment and a record of increased responsibility with zero down time service level agreement with our clients. Confidential is proactive in prioritizing and completing projects in accordance with time schedule, SLA and budget. Confidential has strong knowledge of Microsoft BI reporting tools (SSRS, SSAS) and other reporting tools e.g. Power BI. In addition he is a database administrator with strong technical expertise, excellent written and communication skills, can work flexible to multitask when necessary, independently collaborate with teams across different IT structures. Furthermore, he has led various projects that include ITIL and ITSM Process.

PROFESSIONAL EXPERIENCE:

Confidential

SQL Server Database Administrator

Responsibilities:

• Developed and created the new database objects including tables, views, index, stored procedures and functions, advanced queries and updated statistics using Query Analyzer and Enterprise Manager on the existing servers.
• Promoting query tuning through schema refinement
• Provided development and design assistance to development and other application support teams
• Provided technical leadership to development team through project leadership and technical documentation and outage management
• Promoted data standards, system procedures and security policies, and best practices, e.g. Dev/UAT/Prod environments and QA & release control
• Facilitate the readiness and availability of all database repositories
• Establishes and builds strong working relations and partnerships with Business Units and senior management
• Produced high quality results that meet business and other stakeholder needs, while ensuring the data analysis, design, and development of reports are based on requirements and desired functionality defined by the business and produces quality results that meet business objectives and timelines
• Participated in technical calls; and contributing to technology solutions
• Subject matter expert of the end-to-end operational design and methodology behind the entire environment, and technical resource for operations, technology and management staff (SME)
• Provided database assistance and problem support to application developers, business analysts and business users
• Maintained directory and knowledge of all factors, issues and events that may affect tasks and project delivery
• Maintained periodic database growth rate and performance statistics to support a proactive database management culture
• Provided technical assistance and mentoring for staff for developing conceptual and logical database design and the physical database
• Helped developers improve the performance of query by tweaking it or modifying indexes in TSQL.
• Implemented ITIL Service Operations or Release, Control and Validation.
• Removed unnecessary columns, eliminating redundant and inconsistent data, normalizing database, establishing necessary joins, creating useful clustered index and non-clustered indexes.
• Recognize potential and actual issues, needs and opportunities for improvement in the implementation of ITSM technologies and service management practices
• Rebuilt the indexes on regular intervals and placing the huge table/non-clustered index on the separate file group to improve the performance.
• I worked on Azure Cloud environment implementations
• Provide support in Microsoft Azure/365 Identity and Security
• Manage and provide support in Microsoft Azure/365 Services including SaaS, PaaS, IaaS, and Networking Solutions
• Manage Microsoft Azure/365 to ensure high availability and reliability
• Manage, develop, configure, implement, and manage the systems that comprise the underlying cloud platform
• Monitor and analyzes the capabilities, security, and performance of the systems
• Configure, monitor and maintain Windows servers within a Microsoft Azure cloud environment
• Provide support for cloud servers, including security configurations, patching, and troubleshooting.
• I assist in maintaining system security strategies, process, and procedures
• Provided support in capacity planning, forecasting and evaluation reports
• Designed and created data extracts, supporting SSRS, Power BI, Tableau or other visualization tools reporting applications.
• Managed Security using SQL Logins, Roles and Security Modes for various users including permissions and auditing, penetration and vulnerability tests, and restricting SQL access
• Developed/employed tools that proactively identify database performance issues and bottlenecks
• Analyzed execution plans and generate suggestions for improvement.
• Provided 24/7 SQL Server Database Support and on call rotation

Confidential

Intermediate MSSQL DBA

Responsibilities:

• Refined and automated regular processes, track issues, and document changes
• Assisted developers with complex query tuning and schema refinement.
• Provided 24x7 supports for critical production systems.
• Performed scheduled maintenance and support release deployment activities after hours.
• Created and managed Azure SQL resources with the Azure portal
• Provisioned new SQL databases on the cloud
• Backup and restored Azure SQL Databases.
• Ensured all database servers are backed up in a way that meets the business’s Recovery Point Objectives (RPO)
• Tested backups to ensure we can meet the business’ Recovery Time Objectives (RTO)
• Troubleshoot SQL Server service outages as they occur, including after-hours and weekends
• Developed and maintained scripts, utility jobs and implementing needed software for database maintenance.
• Implemented and managing database clustering, failover and load balance technologies as per client requirement.
• Developed, tested & implemented a robust database backup and recovery strategy with client assistance.
• Requested refreshes pre or post restore activities (e.g. data loads).
• Conducted root cause and analysis for database incidents and problems.
• Configured SQL Server monitoring utilities to minimize false alarms
• Installed and configured SSRS reporting Servers and developing reports
• Scaled out deployment of reports
• Deployed database change scripts provided by third party vendors
• When performance issues arise, determined the most effective way to increase performance including hardware purchases, server configuration changes, or index/query changes
• Documented the company’s database environment
• Managed SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems.
• Managed SSRS reporting Servers and upgrading of reports and reporting services
• Managed SSRS reporting permissions and generating reporting from multiple databases, xml files and flat files
• Configured and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.
• Applied data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations
• Independently analyzed, solved, and corrected issues in real time, providing problem resolution end-to-end. Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members

Confidential

MSSQL DBA

Responsibilities:

• Created, administered & maintained SQL Server databases (production, development, test and staging environment) for various groups such as developers, QA, DA and users and ensured the availability of the database server in a 24/7 environment.
• Used Red-gates and SQL-Centry for Database/SQL Server performance tuning and query optimization
• Trained MS DBAs and BI Administrators before deployed to customer sites for optimum relationship
• Managed the development, design, and implementation of new applications, as well as changes to existing hardware systems and software packages resulting in high performance for clients
• Provided remote support to SQL Servers on customer sites of various companies to prevent downtime
• Implemented MS SQL Cluster (Active/Passive & Active/Active), Multi Node Cluster up to 8 Node for high availability.
• Writing, debugging, and tuning T-SQL, ETL and stored procedures for developers and customers
• SQL Server database physical model creation and implementation (data type, indexing, table design)
• Developed, deployed and managed SSIS, SSAS, SSRS and published them for end users in SharePoint Set up and administered SQL Server Database Security environments using profiles, database privileges and roles.
• Estimated the work involved and the schedule for designing, building, testing and deploying new reports using Power BI.
• Database administration including installation, configuration, upgrades, capacity planning, performance tuning, backup and recovery for high availability
• Ensured regular database performance monitoring and tuning to prevent downtime
• Designed backup and restore strategies and Disaster Recovery solutions to prevent data loss
• Implemented security policy design for current and new applications to prevent data corruption and theft
• Coordinated team meetings with groups for new design/strategies.
• Created database design for new projects support
• Worked with light-speed application for optimizing queries and database performance
• Coordinated change review meetings and facilitated in the management of incidents according to SLAs
• Planned and administered projects, as well as overall programs using PMI Guide and expert judgment
• Collected requirements, performed project scoping, and served as SPOC (Single Point Of Contact) for clients
• Ensured that project and program deliverables and benefits align with clients’ objectives and advice for change
• As needed and appropriate but no less than annually, provided written technology policy guidance to managers, supervisors, staff and consumers/participants.
• Managed desktop & printer maintenance contracts based on the ITIL Service Management model in line with the overall customer strategy of reducing Total Cost of Ownership.
• Developed annual technology goals and detailed plans for goal accomplishment. Prepared, maintained and tested technology disaster recovery plans. Managed external technology projects
• Respected confidentiality in discussed consumer/participant, staff, volunteer and organizational matters; also maintained confidentiality of organization, project, fiscal and personnel related information
• Provided technical supervision to technology interns and supervised other staff as directed. Completed technology staff evaluations and updated technology job descriptions
• Managed annual routine preventive maintenance projects of all hardware and software (ex. BI, data warehouse, and ERP)