Seasoned, technically inclined and highly empowered SQL Server DBA professional with 8 years of versatile experience encompassing diverse areas of Database Administration, Development and Implementation of next generation database solutions with meticulous attention to strongly focused on delivery to agreed business objectives. An individual with inquisitive mind and burning desire to turn strategies and plans into action with tangible impact in order to accomplish organizationâs objectives and goals.
Expertise:
SQL Server 2005/2008 R2/2012/2014/2016
SQL Server Integration Services (SSIS)
SQL Server Reporting Services (SSRS)
Database Upgrade (In-Place/Side by Side)
Microsoft Azure Platform for SQL Databases
Power BI Reporting Dashboard
Always on Availability Groups
SQL Profiler/SQL Sentry/Redgate
SQL Failover Clustering
Replication/Mirroring
Performance Tuning
Power BI Analytics
Disaster Recovery
Oracle Databases 11g
24x7 Production Databases Support
Develop strategy for provisioning, maintaining and securing corporate-wide variety of database platforms i.e. (MS SQL Server, Oracle, MySQL, IBM DB2, PostgreSQL).
Formulates and define SLAs and SOPs relating to database administration service delivery.
Established HA & DR for all financial environments to maximize uptime of 99.999% of database environment.
Ensure compliance, uniform and transparent database system across the enterprise.
Establish and enforce standards, best practices and escalation policies to meet SLAs and performance goals.
Review database design, system integration, security, backup recovery and high availability and make recommendations for improvements and enhancements.
Manage and supervise subordinates to ensure activities completed to render end to end continuity services, resource balance and system documentation.
Demonstrated ability to successfully manage, lead and mentor a team of technical professionals.
Proactive and diligently identified performance bottlenecks for improvements via architectural changes including OS & SQL Server configurations, RAID configurations for SAN, Re-write code logic to break down badly designed tables and implement Microsoft best practices to provision SQL database for client acceptability on system.Â
Provide 24x7x365 database administration support for major projects that considered as golden feather in company
Analyze supply chain processes from application to database end to fix anomalies that cause to degrade performance.
Migrate OnPrem SQL Server database of 400 GB to Azure cloud using MSAsset service with 0% downtime.
Setup disaster recovery for production databases using always on availability groups as primary site is in Florida that considered as always risky due to hurricanes.
Strong experience to work with delimited files, perform data validations and loading into database through SSIS.
Strong knowledge of data warehouse concepts including star schema, snowflake schema and fact-constellation schema.
Formalize end-to-end Enrollment Cube (DWH) requirements by reverse engineering to existing EDW physical data model designed with SAP Power Designer.
Filled Enrollment Cube (DWH) data mart from source with conjunction of business analyst team to offload reports as per business needs using Kyubit Business Intelligence suite.
Perform data reconciliation to ensure that information loaded in dimensions and fact is reliable and accurate.
Drive Power BI data visualization project to create and maintained various analytical KPIs dashboard to slice and dice data.
Proven experience to build attribute relationships, associations, hierarchies, MDX queries and manipulation of multi-dimensional data using SSAS cube.
Extensive experience to enforce business rules, checks and constraints to automate complex processes using triggers, cursors, stored procedures, CTEs and functions.
• Conduct gap analysis on existing database infrastructure to improve highly interoperable performance, availability, security and real time reporting to render reliable services to establish harmony between people and government information systems.
• Ensure adherence to key regulatory demands through deployment of GDPR compliant database security for audit purpose.
• Worked on database infrastructure expansion to bridge new counties, districts and cities data with existing government MIS.
• Focusing and participating to prototype new SOPs and refine existing processes to mitigate database infrastructure downtime.
• Empower business users understanding to interact with database system by arranging pre-implementation workshops and providing user-friendly material.
• Define SOPs in collaboration with higher management to provide access for consuming database services and exchange of data with other government entities and business stakeholders.
• Optimized database infrastructure to reduce cost in terms of licensing cost, disk space and memory up to 35% after placement of hardware benchmarking w.r.t Microsoft best practices in existing infrastructure.
• Involved in code reviews before promoting code to production environments.
• Headed a team of 11 IT Coordinators appointed in different district service centers for rendering smooth database services.
• Flexible, enthusiastic, positive mentorship and growing mindset team player with solid communication and leadership skills to lead tasks to meet the SLA beyond that to develop creative business continuity solutions.
• Planning, designing, installation and configuration of Microsoft SQL Server 2012/2014/2016/2019 to support highly optimized, scalable, reliable, secure and strategic database infrastructure.
• Deployed GDPR security compliance for SQL Server to adhere security standards for various industry spanning Banking, Insurance, Public Sector, Education, Retail and Healthcare.
• Implement proactive health check reports on SQL server production environments to audit resource utilization and issue fixing beforehand occurrence.
• Sound experience to migrate databases from other heterogeneous environments such as Oracle, MySQL, DB2 as well as migration from on-promises to cloud (Azure and AWS etc.)
• Develop custom utilities (SSRS Report Killing, Bulk Script Execution and Unattended Installation Bundle) to mitigate manual database administration efforts.
• Setup and configured alerts on production environments for vigilant monitoring of server resources, jobs and critical processes.
• Proven experience to setup and configure high availability and disaster recovery solution using MSSQL native capabilities such as Always on Availability groups, Mirroring, Log Shipping, Replication and SQL clustering.
• Extensive experience to optimize system performance by identifying IO, Network, CPU, Memory, Instance Configuration, Blocking and Deadlocks bottlenecks with SQL native tools SQL Profiler, Performance Monitor, Trace, XEvents, SQL tuning advisor and DMVs.
• Proficient in query optimization by evaluating indexes, statistics, revamp database design, table partitioning, execution plans and logical joins to gain performance up to the mark in accordance with defined performance benchmark.
• Managed 150 SQL instances with 45 TB size using SQL CMS register for 24x7x365 production support under strict SLA.
• Hands on experience to synchronize schemas and data across different SDLC environments using Import/Export, ETL and schema comparison tool from visual studio.
• Install, configure, patch and cloning of Oracle Applications 11i and R12 instances.
• Create users, roles and assign appropriate privileges on database level.
• Setup hot and cold backup mechanism for point in time recovery.
• Develop Kourne, Bourne and Perl scripts to schedule maintenance cron jobs.
• Develop script to kill hung sessions on database tier that cause to lock operations on database.
• Administration and maintenance of concurrent managers, OHS managers and oracle application server 10g.
• Apply patches for bug fixing and product enhancement on application and database tiers.
• Perform system administration tasks to prepare environment for Oracle Applications.
• Hands on experience to allow authorized access on remote terminals (Putty, VNC etc.) to mitigate security risks on Linux.
• Beginner level knowledge of oracle high availability architecture RAC and data guard Implementation.
• Monitoring Oracle Applications to ensure smooth running of daily activities for 24x7 productions.
• Thorough documentation of all deployments and their respective policies and procedures.
• Technical assistance to developers and consultants during project implementation on all DBA’s related issues.