SUMMARY:

Experienced Developer/Senior SQL Server DBA/Senior Data Analyst focused on adding tangible business value by implementing standards and solutions to meet the needs of teams large and small. Managed, built and led teams that implemented Application/Database Development, New and Re - Architecting System/Database Architecture and Implementing scalable and best coding practices in the Real Estate, Publishing, Pharmaceuticals, Promotions and Financial industry. Led teams that helped increase revenue, reduce costs, reduce risk, increase quality, increase efficiency and solve complex business problems.

TECHNICAL SKILLS:

Design Skills: ETL Process design, database design, flow charts

Programming Languages: T-SQL, XML, XSL, PowerShell, C#.

Environment: s: Windows 95-10, Windows Server 2008-2016, Visual Studio 2005-2017, SQL Server 2000-2017, Azure SQL, MySQL, Postgres SQL, MS Office, SSIS, SSRS, Talend, Amazon RDS, SQL Workbench, Linux, Centos/Red hat

Monitoring Tools: Red Gate Tools, Sentry One, TFS, Spotlight/Foglight, AppDynamics, Resharper

DevOps Tools: Azure, AWS, Docker, Visual Studio, MSBuild, RedGate, Subversion, Trello, Slack, Kibana, New Relic, ElasticSearch, AppDynamics, SonarQube, Splunk, Dell Boomi and Fortify.

Ticketing Tools: RallyDev, Jira, TFS and VSTS.

PROFESSIONAL EXPERIENCE:

Sr SQL Developer/DBA

Confidential

Responsibilities:

Implemented code quality standardization, operations and business workflows, implemented application and browser automation testing as well as improving overall application and database architecture. Worked with and mentored all levels of the company including C-level staff members on how to improve efficiency of processes and improve the usability of the application. Worked with management and company staff to implement faster and more efficient solutions for the companies public facing application through the fixing errors, rewriting existing code and implementing coding/process standards and using new tools. Led initiative to bolster the importance and developer commitment to DevOps within the organization. Enabled the organization to have a more stable and reliable database maintenance process that led to the elimination of an inaccessible application during off peak hours. Served as the go to resource and DBA Lead for everything T-SQL related in terms of best practices, code review/quality, how the internals of an RDBMS works, architecture and database design. Led, consulted and ultimately decided on database administration processes improvements and implementations of installation, configuration, upgrading, patching, performance tuning, backup and recovery, space management, database security, decommissioning of legacy servers, powershell scripting and documentation.

Confidential

Senior Associate/DBA

Responsibilities:

Worked with all work streams that encompassed the Audit360 platform to implement coding standards for C# and T-SQL, which consumed data from several sources including: Bloomberg, Reuters, BNY Mellon, Fidelity, US Ban corp as well as several other financial data providers into a single platform that enabled auditing teams to test and remediate many manual tasks. This enables Confidential to increase efficiency with existing processes, reduce costs all while also ensuring that profits continue to stay net positive. Led coding standard initiatives to performance tune C#, T-SQL and ORM calls, while also providing guidance and mentoring developers on more efficient ways to get the most out of the system. Provided guidance as a DBA Lead/mentor on SQL Server 2014/2016/Azure SQL Architecture, HA/DR/Always on implementation, resource allocation such as CPU, disk, RAM, version upgrades, index review, as well as application and system performance for all environments. Led and was solely responsible for the DevOps initiative within the team. Implemented proactive monitoring using homegrown processes as well as 3rd party tools for database sizes ranging from 75 GB to 770 GB. Led, consulted and decided on database processes including installation, configuration, upgrading, patching, performance tuning, HA/DR set up, data clean up, database security, powershell scripting and documentation

Confidential

Database Developer/Lead DBA

Responsibilities:

Worked with the CTO, CMO, Head of Public Relations and Head of Analytics on enhancing existing listing agent market and sold listings reports, created new listing agent KPI reports as well as reports that illustrated current and historical neighborhood availability, pricing and sales trends. Worked closely with developers as the DBA Lead/mentor to implement coding standards as well as teaching performance tuning techniques for C#, T-SQL and inefficient ORM calls. Worked with the CTO, Director and Manager of IT to implement new architecture for the HA/DR/AlwaysOn initiative, resource allocation such as CPU, disk, RAM as well as version upgrades and index tuning/maintenance. Worked with the CMO, Head of Public Relations as well as the entire marketing team to enhance and improve existing KPI reports that supplemented their market valuation reports called “The Corcoran Report”. Created and implemented automated proactive monitoring using homegrown processes as well as 3rd party tools that helped reduce business risk and business cost.

Confidential

Lead Implementation Engineer/DBA

Responsibilities:

Worked with shareholders, the CIO and developers to implement a new queue messaging system to post changes in real time for users, which increased efficiency and durability in the existing application; enabling the company to offer more educational products to the existing user base while still ensuring the application and system were performing efficiently. Worked with the CIO and developers to implement coding standards and teach performance tuning techniques for T-SQL. Developed database code using T-SQL to foster new features in the application, while also performance tuning existing processes and T-SQL code. Was the DBA Lead and was put in charge of managing and proactively monitoring all hardware hosting SQL Server instances and databases. Created an automated SQL Server Index review, maintenance, application and system performance jobs for all environments using homegrown code as well as 3rd party tools for 100 + databases ranging from 25GB to 670GB for over 1.2 million active users.

Software Developer/ Senior Data Analyst/DBA

Confidential

Responsibilities:

Worked with new and existing; foreign and domestic clients in to deliver solutions for real estate, media websites as well as CRM applications. Worked with different levels of management gathering complex business requirements and translating them into actionable solutions. Developed and performance tuned existing and new processes. Worked with developers to teach how to make their T-SQL code as well as processes perform more efficiently. Created an automated SQL Server index review, maintenance, application and system performance jobs for all environments using homegrown code as well as 3rd party tools to monitor 20 + databases ranging from 20GB to 550GB.