Versatile Database Administrator with 10+ years of experience in SQL Server Database Administrator with a focus on improving the overall performance of the managed servers, securing data access, analyzing SQL Profiler traces, XE, and other monitoring tools. Expertise in working with database sizes ranging from few GB up to 15TB, redesign and optimization of existing business processes, testing and implementing database maintenance processes.
Establish the needs of users and monitor user access and security. Monitor performance and manage parameters in order to provide fast responses to front-end users.
Map out the conceptual design for a planned database. Consider both back-end organisation of data and front-end accessibility for end-users.
Refine the logical design so that it can be translated into a specific data model
Oversaw performance monitoring and optimization, developing backup strategies, implementing backup processes to accommodate the strategies.
Performed operational process optimizations (use of driving table to allow scaling up, transition to SSIS), improving existing processes (driving table and / or transition to SSIS), and developing new processes to address existing performance issues.
Redesigned databases to optimize performance through better database design (files and filegroups, table partitioning, data compression, etc). Redesigned the archival process and improved data import processes.
Administered all SQL Server 2016 databases and provided suggestions for improvement, performing a complete redesign of the database physical design and redesign of the server hardware configuration.
Implemented SQL Server best practices: backup and backup testing processes, monitoring & alerting processes (blocking, long running processes / transactions, Availability Group health).
Deployed new servers and migrated databases to new architecture. Documented existing and new processes, building coding standards and best practices for database development.
Managed a team of two DBAs, covering both production and QA environments. Worked closely with the Database Technical Architect (DTA) to implement and observe policies across all DB servers.
Monitored overall health of production systems, recommending changes to our development team, testing and deploying changes to the indexing strategy, and liaising with the DTA to optimize database physical design from an I/O perspective.
Closely collaborated with developers to implement changes for both performance optimizations and process improvements. Implemented custom index and statistics maintenance.
Managed all business critical systems, including database and application servers. Led business critical projects: Sales Force Automation (involving mobile equipment, 3rd party software, replication, SQL Server 2000/2005), Europe Reporting Database/Datawarehouse, SAP Migration etc.
Developed various on-demand reports (~20 reports) for both internal & statutory use using ASP 2.0, IIS, HTML and SQL Server 2000 as backend (ERP database), also leading a team of 2 BIS specialists.
Managed and maintained all security aspects of daily operations: antivirus, internet security, email security, and provided management reports for out-of-ordinary internet activities.
The project involved the full automation of the whole import process from a manual process taking few days to complete to a process running for 3 to 6 hours, depending on the volume of data being imported and other run-time factors. Managed to redesign the data import process from 3rd party sources using SSIS, FTP, and TSQL. The process also allowed a seamless transition between previously imported data sets to the current one, with minimal downtime (<1 minute). In case it was needed, a full reversal to the previous data set was also possible.
The project involved replacing a large number of ad-hoc, on-demand, and scattered data import processes with one unified and consolidated data import for various purposes from the central ERP (Dynamics AX) to one local database. Used a combination of SSIS and TSQL (stored procedures) to accomplish the task.
The project was the design and implementation of a data archival process for a multi-TB database with no or minimal downtime requirements. Implemented it using table partitioning, SSIS, and TSQL (stored procedures). Overall downtime for weekly archival for ~700 million rows < 3 minutes. Part of the archive data uploaded to S3 for long storage, as part of the process.
Education
Microsoft Certified Trainer; MCSE: SQL Server 2016 Data Management and Analytics; MCSA: SQL Server 2016 Database Administration; MCSA: SQL Server 2016 Database Development;