Shobhendu Sunder Deo

PERSONAL DETAILS

Date of Birth: 25/09/72

Nationality/Citizenship: Australian Citizen

Email: adcnaz@r.postjobfree.com

Tel: 011**-**-***-**** or 213-***-****(Mobile)

Suburb, Post Code: Carlingford,2118

LinkedIn / Github URL’s: https://www.linkedin.com/in/shobhendu-sunder-deo-6894a512/ / https://github.com/shobhendu2509

PROFILE SUMMARY

An enthusiastic IT professional with over 15 years of industry experience in IT/Financial Markets combined with a track

record of delivering change at a project and database tier.

Covering a variety of high-profile projects ranging from new product implementations to decommissioning systems I have gained extensive experience in managing teams distributed globally and diversified in technologies.

Recognised for the ability to identify and mitigate risks, plan and manage complex high visibility projects aligning business goals with technology solutions to drive process improvements and optimise total cost of ownership.

CAREER DIRECTION & INTERESTS

I have an interest in architecting, implementing and maintaining application databases across all business tiers using the latest .NET technologies with a particular interest in;

Microsoft SQL Server, Oracle and DB2 RDBMS and windows services as well as integrated solutions using discussed RDBMS.

High interest in design and implementation of Always On High Availability, performance tuning, encryption, security

Low latency high performance user interface development in a multi-tier /distributed environment.

ASP.NET MVC pluggable architecture design as well as Microsoft Azure Services which I currently work on.

SIDE PROJECTS

To keep my technical skills up to date, I am currently replicating maintenance tasks using Brent O’zar and Ola Hallengren scripts on Windows Server 2019 with Microsoft SQL Server 2019 and co-existence on Linux Docker. I do this after work or during my spare time (mostly weekends).

I have collaborated on several development projects in the past, including the successful launch of ePASS.

TECHNICAL COMPETENCIES

Core skills

SQL Server, Azure SQL, Entity Framework, SCCM, SharePoint, Power BI, SSIS,SSRS

Agile Practices

Scrum, Waterfall and DevOps Test Driven Development

Source Control/Build

Team Services on Azure, TFS

CAREER HISTORY

Microsoft Partners

Senior Architect and Database Administrator February 2019 – February 2020

Mandate & Responsibilities

Design/Assess/Migrate/Upgrade of Databases Instances or Managed Instances towards Legacy Application. Architecting of High Availability with Always On and Disaster Recovery Solution for various Federal Government and Non-Government Client. Involved in setup of High Availability solution using SQL 2017 in both Azure and On-premises environment.

TECHNOLOGY:

Server: Windows 2016, SQL Server 2017.

Active Directory Domain Services

Domain Name System (DNS)

SCCM

SCOM

PowerBI

Key Clients:

Healius HealthCare Private Limited- St. Leonards, Sydney

Queensland Government HealthCare- Brisbane

MyState Bank- Hobart

SeymourWhyte-Queensland

Followmont Transport – Brisbane

Department of Foreign Affairs and Trades- Canberra

Australian Federal Police- Canberra

Standards Australia- Sydney

ComCare- Canberra

MYOB- Melbourne

SA Police- Adelaide… and many more.

Upon joining, tasked with healthcheck, rebuilding, migration and disengaged development team of 10 people & re-architecting and modernising the company’s product suite by introducing the latest technologies, tools and methodologies aimed at significantly increasing quality and speed of delivery.

Responsible for the architecting, delivery and management of all development across non-production to Production environment with a make-up of 10 developers;

Reporting directly to the CEO

Management of 3rd party applications

Management of .NET based web/client portal for managing client collateral positions

Part of the IT management team governing IT strategy, stakeholder management and day-to-day management across all areas of Collateral IT.

Project planning and development using AGILE and Waterfall methodologies.

Achievements, Awards & Major Deliverables

Partnered with a 3rd party search firm to implement a disruptive & best practice hiring framework that helped us significantly increase quality of hire from 52-94% & increase headcount from 8-22 developers in a 12-month timeframe. Whilst cost per hire increased, attrition is now <7% and staff engagement was last measured at 92%.

Frequently promoted within APS public services 4 times (EL1.1 > EL1.2 > EL1.5) in 4 years & regularly commended for taking on ePASS projects and ComSAS and Capital division wide process improvement initiatives.

SarasAmerica Inc., USA

Senior Database Administrator May 2017 – December 2018

Mandate & Responsibilities

Migration/Upgrade of Databases Instances Legacy Application from MS Excel/MS SQL Server 2012 and SQL 2014 to SQL 2016. I was engaged by SarasAmerica to Architect and reverse engineer client’s data to Microsoft Supported SQL instances and Infrastructure.

TECHNOLOGY:

Client Data: Windows 7/10, Flat Files, MS Excel 2013.

Server: Windows 2008-2016, SQL Server 2008-2016.

Active Directory Domain Services

Active Directory Sites & Services

Domain Name System (DNS)

Dynamic Host Configuration Protocol (DHCP)

Microsoft Baseline Security Analyzer (MBSA)

Microsoft Internet Information Services (IIS)

Microsoft Office(Word, Excel, PowerPoint, Access, Visio, Project, Outlook and Skype)

Microsoft SharePoint

System Center Configuration Manager (SCCM)

System Center Data Protection Manager (SCDPM)

System Center Operations Manager (SCOM)

System Center Virtual Machine Manager (SCVMM)

Windows PowerShell (ps ise) / Command Shell scripting (cmd)

Windows Server Manager

Visual Basic Scripting Language (VBScript)

Key Clients:

Ford Automobiles- Dearborn, Detroit, Michigan USA

Dominoes Pizzas – Farmington Hills, Michigan, USA

Achievements, Awards & Major Deliverables

Successful health check of SQL Server configurations, consolidation and migration of Ford Automobile data from legacy installation to virtualized VMWare and/or Azure environment. The SQL Server RPO and RTO successfully improved after the implementation to five 9’s and client applications response times from 10-12 hours to under 1 hour.

Commonwealth Superannuation), Canberra, Australia

Senior Architect and Database Administrator Dec 2010 – Apr 2017

Mandate & Responsibilities

Dataload, management and upload of Australian Electoral Commission (AEC) data for the 7 Australian States.

Expertise in architecture, configuration and deployment of ePASS version 2.14.x/2.16.x/4.1.x/4.2.x and finally 6.x.x

Point of contact for initial diagnosis of problems, for a system or sub-system or apply known solutions, including documenting problems, progress checking, and escalation to ensure resolution discussion with Bravura vendor, Business Team and off-shore development team.

Follow-up in relation to improvement with ePASS response times, performance resolution and troubleshooting aspects within tomcat web tier/JBOSS and Ant application tier/MS SQL Server database tier and/or integrated ComSAS IBM DB2/Capital Oracle projects.

Key contributor for providing sampled scrambled data to Bravura for the ePASS versions (2.14.x/2.16.x/4.1.x/4.2.x and finally 6.x.x) upgrades and then architecting the infrastructure, deploying the military and civilian super funds onto the new hardware infrastructure.

Managing activities like building new database environments for applications, installing SQL related software like ePASS, RazorSQL, Helpmaster Pro, MiAudio, Zeacom & SQL Server 2012

Mentoring a team of 6-10 Junior DBAs in data modelling, design and cost-effective scripting so as to be propagated to Test, UAT and Production environment

Creating databases for new applications; setting up recovery and DR processes and configuring Log shipping. Implementing Advanced Compression and Restore methods for databases.

Setup of HADR with Synchronous one secondary replica using SQL 2016. The data is replicated to DMZ remote site.

Implementation of Government Stipulated Security guidelines and policies which included granting access to only DoD individuals who had Highest Security Clearance.

Maintenance of vendor SSRS reports and creation of in-house Business Intelligence reports to generate heat-map and comply with Government SLA policies.

Creation of data dictionary for future analysis of Datawarehouse and migration of SSIS packages onto newer infrastructure.

Architecting and implementation of solutions onto production servers. Strong SQL database upgrade and migrations onto newer OS platforms or replicated platforms using VMWare (VCenter) or Hyper-V.

Creating and maintenance of web-portals for Government Clients using SharePoint 2007 or 2013.

Analysing, designing, building and implementing Cloning of PROD and other environments (e.g. to investigate production issues) using scripting, SQL and PL/SQL

Designing, creating and automating job schedules and implemented them through SQL Server

SQL Server, SQLIO, Redgate Toolbelt and MSBSA installation, configuration, health check and monitoring

Architects and other stakeholders for database design issues (Business Intelligence Databases, Cloud computing)

Creating backups and restore points; export/import of databases for migration.

Working on Databases running into multi-Terabytes (TBs); Used internal feature for moving large volumes of data between MS SQL databases; Troubleshooting DB connectivity & availability issues

Perform day-to-day BAU support tasks like backup and recovery of databases, Monitoring PROD and NON-PROD backup jobs, catalog maintenance, refreshes, troubleshooting various scenarios, taking actions on alerts from SQL Jobs and other automated tools, performance monitoring and tuning using SQL advisors, code review for projects, ensuring accuracy, integrity and security of application data are maintained, on-call support etc.

Other BAU tasks like preparing documentation, including recording the procedures, standards, guidelines, and data descriptions necessary for the efficient and continuing use of the database environment.

Automation of day-to-day BAU tasks like health checks

OAT (Operations Acceptance Testing ) and DR testing from DB point of view

Monitoring DB/SQL performance and tuning using SQL Tuning Advisor, SQL Profiler etc. (supporting and analysing testing)

Generated vmstat, pmon reports on Windows to capture CPU, Memory, IOPS and Load Average utilization metrics at OS level.

Performance tuning using Perfmon, Resolving Lock and Latch contention.

Administering database maintenance activities (Starting/Stopping/Garbage cleanup/Purging old files/Index rebuilds etc.)

ACHIEVEMENTS:

Bestowed with a cash award for fixing an outage in the business-critical system.

TECHNOLOGY:

ANT, Capital, COMSAS, Edition, Helpmaster Pro, IBM DB2 10.5, IIS, JBOSS, MiAudio, Oracle ODAs, RazorSQL, Redhat 5.0, SQL 2005 – 2016, SQLIO, SUSE Linux 11, Tomcat, Windows 2000 EE/2003 EE/ 2008EE / 2016 EE, Zeacom, Brent Ozar Health Check SPROCs., Confluence, JIRA. Server: Windows 2008-2016, SQL Server 2008-2016. Active Directory Domain Services/Active Directory Sites & Services/Microsoft Baseline Security Analyzer (MBSA)/Microsoft Internet Information Services (IIS)/Microsoft Office(Word, Excel, PowerPoint, Access, Visio, Project, Outlook and Skype)/Microsoft SharePoint/System Center Configuration Manager (SCCM)/System Center Data Protection Manager (SCDPM)/System Center Operations Manager (SCOM)/System Center Virtual Machine Manager (SCVMM)/Windows PowerShell scripting (ps ise)/Windows Server Manager/Visual Basic Scripting Language (VBScript)

Microsoft, Redmond, USA

Operational DBA November 2009 – January 2010

Mandate & Responsibilities

Migration of Databases/Data from MS Access and MS Excel to MS SQL Server 2012. I was engaged by Microsoft to assist EMC2 clients in their data migration.

TECHNOLOGY:

Client Data: Windows 7, MS Access 2013, MS Excel 2013.

Server: Windows 2008 EE, SQL Server 2012.

Previous IT Summary (pre-2009)

Company - Location

Dates

Role - Technologies

Domain / Business area

RFL’s (reasons for leaving)

State of Connecticut, Hartford USA

Feb 08 – Oct 09

(1 yr 08 mths)

Senior SQL DBA

Department of Children and Families, Connecticut Juvenile and 37 other organizations

Visa renewal constraint within US Public Services.

Australian National University, Canberra, Australia

Jul 07-Feb 08

Database Administrator

ANU IT and Infrastructure Division

Salary increase and better career prospects

Quick Summary

Engineer with 12+ Years of rock-solid IT experience in vital roles.

An award-winning Architect who has managed key projects for Microsoft.

Highly experienced in setting up large TB database environments.

Vigilant about data security and knows how to protect it.

Proficient in managing key migration projects and automation of processes.

Saved millions of dollars for clients by implementing solutions.

Understands Waterfall/Scrum Agile methodology, government guided compliance and SLA’s.

Knows how to make things happen.

Cool under pressure.

Sound understanding of PASS, SAAS and IAAS.

EDUCATION

1994 – 96 KVG College of Engineering, India

B.E degree Electrical and Electronics Engineering

PERSONAL INTERESTS and ACTIVITIES

I regularly keep up-to date on the latest financial affairs which has ultimately attracted me to work in the financial industry. The constantly evolving environment, especially in recent times has proven to be a constant attraction to learn more about the mechanics of the financial industry and how it impacts the world we live in today.

I’m a keen lawn tennis player and a boating enthusiast and thereby have participated in many dragon boat race to support breast cancer social charity events.

I am also a father of a boy and a girl and have found it a very useful opportunity to fine-tune keys skills such as organisation, prioritisation and time management.

Skillset Summary

Contact this candidate