SUMMARY

• Information Technology subject matter expert focused in on - premises and cloud database infrastructure and business intelligence technologies using AWS, GCP, Azure, MS SQL server, Confidential, MySQL, PostgreSQL and Microsoft SharePoint server, with dedication and passion to innovate and implement best practices, directing design and delivery of advanced infrastructure technological solutions.
• Recent 4+ years in AWS, GCP, Azure cloud infrastructure setup and maintenance with big data specialization.
• Strategic Planning & Coordination in trouble shooting database systems.
• Expert in Clustering High Availability, Always-On and NLB Load Balancing.
• Experienced in AWS Cloud technologies VPC, EC2, EBS, S3, CloudWatch,
• ElastiCache, Route 53, ELB, RDS, DynamoDB, RedShift, EMR, Kinesis Stream/firehose/Analytics, OpsWorks,
• Experienced in scripting using Powershell, Python, Node.js, Scala
• Very Strong experience in Architecting, Installing, maintaining large scale on premises SharePoint farms, on cloud O365
• Deploying virtual environment from scratch using VMware ESXI 6 and 6.5 virtual host, vCSA infrastructure.
• Setting up and maintaining webserver & web applications using IIS and Tomcat plus debugging and troubleshooting issues.
• Technical Security Risk & Vulnerability Assessments for application deployment.
• High Availability and Disaster recovery Database Infrastructure Design, Optimization & Administration.
• Design, improve and optimize business intelligence data load process.
• Business Continuity process / Disaster Recovery Management.
• Designing and Deploying database task automation and monitoring scripts.
• Managing Systems Development Lifecycle Process.
• Designing Roadmaps, Policies, Procedures & Standardization Documentation.
• Project Planning and coordination with senior Management and business stakeholders.
• Writing wiki for Best Practices & technique improvement.
• Team Training, Mentoring & Leadership.
• Strategic Planning & Coordinating operational support to maintain proactive maintenance.
• Analyzing compatibility, capacity and performance issues.

TECHNICAL SKILLS

Database: MS SQL Server 2016, 2014/2012/2008 , Confidential 11g & 12c, MySQL, PostgreSQL, MongoDB, DynaMoDB, RedShift, Hbase, Hadoop

Data Streams: Kafka, Kinesis Streams, Kinesis Firehose, Spark streams

Data Analytics: SparkSQL, Tableau, Qlikview, PowerBIETL SSIS, Informatica, Lamda, Knifi, kylo, Talend, DataStage: AWS:

VPC, EC2, EBS, S3, CloudWatch, ElastiCache, Route 53, ELB, RDS, DynamoDB, RedShift, EMR, Kinesis Stream/firehose/Analytics

OpsWorksServer OS: Windows, RedHat, CentOS, Fedora, Ubuntu

Content Mgmt: SharePoint 2016, SharePoint 2013, SharePoint 2010

Systems: Active Directory, DNS, DHCP, IIS (DMZ/AAR), SCOM, SCCM

Tools: Sybase PowerDesigner, Visual Studio 2013, Automator, Quest Spotlight & Foglight, Litespeed, SQL deadlock detector, Logman, SQL Nexus, AvePoint Docave,, SharePoint Data Migration.

Big Data Tools: Spark, Kafka, Nutch, SOLR, Lucidworks Banana, Knifi, kylo

Scripting: PowerShell, Python, Node.js, C#, Scala, T-SQL

YEARS OF EXPERIENCE

Confidential, NYC

Database Systems Engineer

Responsibilities:

• 17+ years of DBA MS SQL server 2016, 2014, 2012, 2008 and 2005 database engineering production support experience.
• 17+ years of Windows Server system maintenance AD, Azure AD, DNS, DHCP, GP, ADFS, SCCM (SMS), SCOM (MOM).
• 15+ years of data science intelligence / data warehouse architect experience.
• 7+ years of experience in Confidential 11g, RAC, RMAN, DataGuard, PostgreSQL, MYSQL.
• 10+ years of experience setting up Windows multi-node Clustering, NLB, IIS.
• 8+ years’ experience in IIS, .NET C# application design, development and debugging
• 7+ years of experience in customizing and procuring powerful enterprise server systems.
• 6+ years of VMWare vSphere, Citrix XenApp technologies
• 5+ years’ experience in Cisco Networking Switch, Router, Firewall implementation
• 5+ years Linux operating systems (RHEL, CENTOS, Ubuntu etc.)
• 4+ years of AWS, Azure and GCP cloud solutions maintenance and architect experience
• 2+ years of MongoDB, SOLR, HBASE, NUTCH, SPARK, Hadoop HDFS systems in AWS cloud.
• 2+ years of experience in installing ElasticSearch, Atlassian products such as Jira, Confluence, BitBucket and Bamboo.
• Managing and Coordinating Offshore Big Data project development process.
• Performing as Liaison facilitating the requirements and guidelines between developer and the business.
• Defining Project blueprints, technical road maps and security standards.
• Conducting periodical project management meetings maintaining developer follow-up task items and meeting notes and providing weekly status update to the senior management.
• Spinning out AWS EC2 instances and S3 storage.
• Implemented streaming technologies like Apache Kafka. Apache Storm, AWS Kinesis.
• Worked on implementing AWS Elasticache, AWS Lambda, AWS Athena, AWS Redshift and AWS RDS Aurora
• Creating and configuring AWS pipeline for data migration to and from S3, Dynamo DB and Redshift database.
• Installing and maintaining MongoDB, MYSQL, SOLR, HBASE, NUTCH, SPARK, Hadoop HDFS systems in AWS.
• Implemented Orchestration tool like Apache NiFi
• Implemented and maintained ETL tool like Informatica, Talend and SSIS
• Also worked on Tableau, Qlikview and PowerBI

Confidential, NYC

Lead Database Systems Engineer

Responsibilities:

• Lead Database systems engineer for 24/7 global shared services IT department, managed 3-member DBA team.
• Designed, Deployed and maintained a large scaled out SharePoint 2007 and 2010 production farm of initial size 8TB eventually planned to grow up to 32TB.
• 24/7 responsible for database related server uptime and major incident management.
• Main go to person for both SQL server and Confidential database related development solutions, issues / resolution and resource assignment.
• Mainly focused on engineering tasks such as architecting high availability, disaster recovery designing and documenting proof of concept and risk assessment.
• Architected and installed multi node / multi instance production SQL server failover cluster infrastructure.
• Designing & configuring SQL 2008 Synchronous and Asynchronous mirror solution.
• Designed and deployed scale-out and load balanced SSRS reporting solution.
• Proposing and demonstrating new technical architecture to the senior management.
• Designing and documenting SLA’s (RPO’s & RTO’s)
• Database server inventory maintenance comprising 100+ SQL server instances (stage and Prod).
• 24/7 on call tier 3 support as lead database engineer.
• Designing backup and recovery strategy for both SQL server and Confidential
• Defining Hardware and software specification for new and enhancement projects.
• Delegating and coordinating trouble shooting tasks and tickets.
• Overseeing and coordinating Database consolidation projects.
• Reviewing and approving problems and resolutions.
• Architecting DR replication mechanism for full infrastructure, instance only, database only failover strategy.
• Maintaining Change management and patch management.
• Working with security and compliance department.
• Designing and Deploying 24/7 database monitoring, alerting and reporting mechanisms.
• Reviewing change documentations.
• Creating, maintaining and managing Server run books, How-to and FAQ documentation for team members.
• Experience in using LightSpeed, Foglight, Spotlight, Double Take and Avepoint Docave tools.
• Importantly handling other project management pressures.
• Conducting team meetings and participating in other project related meetings.
• Interviewing and hiring contractors and team members.
• Sound knowledge in Win 2003/2008 AD, DNS, EXCHANGE 2010, LYNC 2010, VMware, CITRIX.
• SharePoint 2010, 2007:
• Installed and maintained stage and Prod SharePoint 2010 farm 4 WFE, 3 App and 2 Search servers backed up by a MSSQL multi node multi instance failover cluster.
• Installed and managed test/Stage/Prod MOSS 2007 farm with 3 virtual web frontend load-balanced with Netscalar.
• Configured a SharePoint embedded SQL server reporting service.
• Managed SharePoint backup and restore using Avepoint and native SQL server.
• Installed and maintained DR Failover solution for SharePoint.
• Installed and configured Confidential 11g database on Dev/Test/Prod system on windows.
• Architected and deployed Confidential 11g standalone instance, RAC, DATAGAURD.
• Day to day monitoring, provided disaster recovery solution by configuring and maintaining physical standby database using Confidential Data Guard.
• Worked on database cloning to make Production instance available for Test and Development.
• Created users and involved in database security by granting roles, privileges, and profile to users.
• Developed PL\SQL stored procedure, package, triggers, cursors, and views.
• Performed, developed and maintained database backup and recovery using RMAN.
• Performed logical backup of database, schemas, tables using Export/Import and DATA PUMP utility.
• Describe your responsibilities and achievements in terms of impact and results. Use examples, but keep it short.

Confidential, NYC

SQL Database Administrator

Responsibilities:

• Worked mainly on production maintenance, server migration and consolidation.
• In charge of Production database code change and quality control.
• Verified the daily and hourly backups.
• Monitor SQL server replication and log shipping status.
• Check for job status disk free space and free space on database data and log files.
• Check SQL server error logs and windows event logs.
• Collect and Bench mark SQL server Performance statistics and recommend query optimization.
• Scripting objects, creating and granting access to objects, maintain log for newly deployed and changed objects in production.
• Weekly and monthly weekend maintenance tasks
• Database migration and consolidation. DTS to SSIS ETL conversion and migration.

Confidential, NYC

Senior SQL DBA / offshore projects coordinator

Responsibilities:

• Configured & maintained SQL clusters, replications and mirroring.
• Monitored Backup Developing SSIS packages integrating data from different database source and structure.
• Developed Business Intelligence Packages. Configured Backup strategies and disaster recovery plan.
• Organizing and coordinating offshore application development projects, recommending solutions, Getting involved in testing and approval process

Confidential, Westbury, NY

DBA / .NET Developer

Responsibilities:

• Responsible for Maintaining SQL 2000 server and ASP.NET application design & development for multi-tier, enterprise-level accounting applications using C# and ASP.NET.
• Designed Macros for data manipulation in Excel, generating reports in Crystal reports automating outlook sending reports.

Confidential

Database Administrator / Team lead Developer

Responsibilities:

• Maintaining, and optimizing the database performance; designing and implementing new databases for various projects according to the requirements from clients; establishing and maintaining database security in development and production environments.
• Writing project requirements and designing application architecture.

Confidential

Senior Software Programmer

Responsibilities:

• Collaborated on team of eight Programmers to develop business applications for inventory controls, financial applications for banking companies, payroll package for government corporations using Confidential and visual C++