Multi-dimensional and career-driven professional credited with over six (6) years of solid experience resolving complex inquiries, capable of holding positions of great responsibility. Digest several new thoughts after having attacked and overcome the latest performance or space issue and started considering aspects of a seemingly simple query that isn't performing as anticipated. A dynamic and passionate individual with a proven track record of finding ways to store, organize, and manage data with expertise in liaising with programmers, applications/operational staff, IT project managers, and other technical staff. Ensure success as a database administrator by providing key data recommendations and best practice solutions to project teams. Committed to utilizing resources to drive significant decisions and assimilate new concepts, ensuring integrity and accountability through transparency and actionable insights. Viewed as a path of resistance to a development team and must walk the fine line of ensuring security & availability while at the same time not hampering delivery. AND ACHIEVEMENTS
- Excellent knowledge of databases and query languages, and intimately familiar with the steps required to perform the work.
- Spearheaded over 500 databases and VLDB across multiple data centers and migrated SQL data from on-premises to Azure SQL database, Azure VM and AWS. Performed Physical and Logical Data Modeling for databases of varied sizes, including VLDBs.
- Set up and sustained high availability and disaster recovery solutions and large-scale database migrations from SQL Server 2005 to SQL Server 2012R2 and 2014, 2016, 2017, 2019.
- Aided the SQL server prime customers with configuration, administration, implementation, and troubleshooting for business workflow with the Log shipping mechanism and installed and maintained SSIS, SSRS, and Power BI.
- Configured DR solution with transaction replication from distribution server with multiple updatable subscriptions.
- Developed and maintained SQL objects like Tables, Views, Stored procedures, constraints, and user-defined functions.
- Achieved Database consistency checks with DBCC, Defrag, and Index tuning monitored error logs and implemented Log Shipping from Primary to Standby servers. Conducted scheduled backups and restored operations with LiteSpeed 4.5.
- Implemented Log Shipping from Primary to standby servers and used tools like SQL Profiler and Red Gate for monitoring the environment. Involved in creating and developing SSIS packages in SQL Server 2008
- 17
- Crafted shell scripts and SQL scripts for database administration to support DBA function and assisted developers with complex query tuning and schema finessing.