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, ORACLE, 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.
• 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 ORACLE 11g, RAC, RMAN, DataGuard, PostgreSQL, MYSQL.
• 10+ years of SharePoint 2016/ 2013/2010/2007
• 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’ experience in implementing Exchange 2013/2010/2007 , SharePoint, Ms CRM, BizTalk
• 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.

CORE COMPETENCIES:

• 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 , ORACLE 11g & 12c, MySQL, PostgreSQL, MongoDB, DynaMoDB, RedShift, Hbase, Hadoop

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

Data Analytics: SparkSQL, Tableau, Qlikview, PowerBI

ETL: 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, OpsWorks

Server 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

PROFESSIONAL WORK EXPERIENCE:

Confidential, NYC

Database Systems Engineer & SharePoint Architect

Responsibilities:

• Consolidating, upgrading, enhancing and optimizing existing SQL servers.
• Mentoring and leading 5-member developer team, coordinating and assisting them in terms of query optimization, performance tuning, code review, change control and application development life cycle coordination.
• Designed, developed and deployed a SharePoint/InfoPath/Approval workflow based corporate wide Change Management Control application.
• 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
• Self-starter initiating new database projects, introducing and delivering proof of concepts to consolidate and cut down license cost.
• Recommending hard and soft server requirements for next budget year.
• Defining database server road maps and server standards.
• Responsible of maintaining EMC storage replication.
• Setting up veeam backup and replication.
• Facilitating developers by setting up new windows and Red Hat / Centos Linux server requirements.
• Identifying and rectifying resource bottlenecks.
• Automating PowerShell scripts for daily server health check. Frequent index, stats and performance checkups, Optimizing, query tuning and troubleshooting production and developer query performance problems.
• Designing backup and recovery strategy for both SQL server and ORACLE.
• Providing de-normalization, dimensional model and ETL SSIS process recommendations to developers, helping on issues related to reporting tools like SSRS, QlikView and Tableau. Data Warehouse/Business Intelligence Lifecycle Management using in-depth knowledge from Kimball University.
• Frequently involved in planning and executing database server migration, installation and upgrading projects. Implementing high availability Active passive WSFC cluster.
• Implementing Always-On, Mirroring and replication solution.
• Worked coordinating the 5 node Nutanix storage system deployment with Nutanix sales team and technician.
• Got trained in Nutanix prism maintenance and was fully in charge of configurational changes.
• Was also in charge of setting up the same in DR and setting up the replication in-between.
• Review, Plan, Implement, Migrate and Test to provide recommendation about cost effective database server technology solutions as a proof of concept.
• Delivering and documenting Oracle12C, Hadoop, PostgreSQL, MongoDB, Cassandra on Linux OS (Centos or RHEL) as an alternate cost-effective database server solution for data growth and performance.
• Work on tools for data visualization.
• Negotiating and documenting SLA (RPO’s & RTO’s), Recommending development and deployment best practices. Recommending best performing query logic.
• Reviewing code security and process security with developers before production deployment.
• Administrating and Maintaining Production change management control.
• Conducting periodical database project team discuss sessions.

SharePoint Farm Architect

Confidential

Responsibilities:

• Currently working in SharePoint 2016 upgrade project.
• Design Developed and Deployed scaled-out & Load balanced SharePoint 2013 farm completely using PowerShell scripts on Windows 2012 and SQL server 2014 High Available Cluster.
• Upgraded SharePoint from 2007 to 2010, and again upgraded from 2010 to 2013.
• Gather requirement, design application mockups, Architect, Define solutions.
• Customizing SharePoint master page theme by defining custom CSS and client-side scripting for a neat enterprise content portal intranet theme look.
• Taking care of audit, security, Backup and access request.

Web server Admin

Confidential

Responsibilities:

• Built and maintained IIS, TOMCAT web server.
• Taking care of Production code deployments.
• Configuring and troubleshooting IIS server performance.
• Deployed and Maintained SharePoint, MS CRM, HRIS, Jira, GIT web applications.
• Upgraded and migrating from Windows 2012 cluster to windows 2016 Clusters.
• Win 2012 Fail over clusters, PowerShell scripting. Deploying, Maintaining and troubleshooting Active Directory, Exchange 2013, DNS, DHCP, IIS (DMZ/AAR), SCOM, SCCM.
• Knowledge in RIP, OSPF, BGP routing protocols.
• Installing and troubleshooting Linux servers.
• Deploying application on Red hat and Centos servers.
• Setup production VMware vSphere virtual host for Red hat license registration by installing virt-who.
• Reviewing vendor documentation. Facilitating technical requirements.
• Recommending best practices.
• Shadowing remotely and documenting while installation and troubleshooting process.

Confidential, NYC

Lead Database Systems Engineer & SharePoint Admin

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 ORACLE 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.
• Defining corporate wide database road map, standards and best practices for the entire organization.
• 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 ORACLE
• 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 ORACLE 11g database on Dev/Test/Prod system on windows.
• Architected and deployed ORACLE 11g standalone instance, RAC, DATAGAURD.
• Day to day monitoring, provided disaster recovery solution by configuring and maintaining physical standby database using Oracle 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.
• Involved in .net production application deployment and configuration.

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.