Role Technical Manager - Database

Environment/Skills

MSSQL Server and MySQL Database Administration, MSSQL and MySQL on AWS, Backup archiving to AWS S3 using Cloudberry, Managing databases using Idera Diagnostic Manager and Monyog tools, Mirroring, Semi-sync replication, High availability, DR solutions, performance tuning.

Work Details

• Managing large application product’s database infrastructurein MSSQL and MySQL servers of 2000-2016 MSSQL and 5.0.x-5.7.x MySQL.
• Creating scalable MySQL& MSSQL cost effective infrastructure and monitoring using IDERA Diagnostic Manager and Monyog tools.
• Implementing databases maintenance solutions for MSSQL and MySQL.
• Upgrading (in-Place and side by side) and patching MSSQL and MySQL servers with latest updates.
• Resolving database related issue on MSSQL and MySQL servers. Performance tuning on MSSQL and MySQL innodb servers.
• Deploying database scripts onto MSSQL and MySQL.
• Configuring MSSQL and MySQL fault tolerance infrastructure, cluster, DR, HA.
• Admintrating and resolving issues on MSSQL mirroring and MySQL replication.
• Configuring automation scripts to easy administrative tasks.
• Percona xtra backup for MySQL servers and achieving MySQL &MSSQL backups to AWS S3 using Cloudberry.

Role

Database Administrator

Environment/Skills

MSSQL Server and MySQL Database Administration, MSSQL Azure, Database Migration, Performance Tuning, Log Shipping, Clustering, Replication, SQL Server Reporting Services, SQL Profiler, Diskspd utility, Avamar, MySQL Enterprise Backup(MEB).

Work Details

• Managing large e-commerce database MSSQL and MySQL servers of 2000-2016 MSSQL servers and 5.0.x-5.7.x MySQL servers.
• Upgrading (in-Place and side by side) and patching MSSQL and MySQL servers with latest updates. Upgraded MSSQL servers from 2000 to 2012 directly using linked server. Converted MySQL servers from enterprise edition to community edition.
• SQL server 2014 Azure database setup and migration to premium storage.
• Migrated MSSQL encrypted databases and reporting services.
• Resolving database related issue on MSSQL and MySQL servers. Performance tuning and load testing on MSSQL and MySQL innodb servers.
• Deploying database scripts onto MSSQL and MySQL
• Configuring MSSQL and MySQL server, cluster, DR, HA.
• Admintrating and resolving issues on MSSQL and MySQL replication.
• Configuring automation scripts to easy administrative tasks.
• Avamar backups for MSSQL servers.
• MEB and Percona xtra backup for MySQL servers.

Role

Database Administrator

Environment/Skills

SQL servers 2000-2012,Sybase,Always On, MS Clustering, Reporting services, BMC remedy, Commvault backup.

Work Details

• Administrating MSSQL 2000-2012 servers on clustered and non-clustered environment.
• Migration Sybase databases to MSSQL 2012 servers and resolving migration issues.
• Configuring Always on availability cluster and DR environment.
• Configuring reporting services.
• Upgrading and patching MSSQL servers.
• Resolving databases issues and performance tuning.
• Building architecture for MSSQL servers consolidation into ESXi box.
• Implementing automated scripts to monitor databases status and backup status.

Role Database Administrator

Environment/Skills

SQL Server 2005-2012, Profiler, DTS, Log Shipping, Tuning advisor, Import/Export Wizard SSIS, SSAS, SSRS, Microsoft Clustering Services(MSCS).

Work Details

• Administration of multiple SQL Instances on clustered and non-clustered SQL servers 2005-2012.
• Installation and configuration of SQL server on clustered Microsoft Windows Server 2008 R2 Enterprise Edition on SAN environment with minimum access privileges.
• Capacity and configuration planning for SQL server SAN space, memory and CPU for high performance.
• Migrating SQL server to higher version in legacy mode along with objects and logins. Also created DTS package for data transfer between the two environments.
• Upgrading SQL server to higher version with side by side and In-place strategy.
• Planning for server consolidation for cost saving with best performance and utilization.
• Handling critical issues and fixing it with best solution.
• Experience in ticketing tools like Kintana and ServiceNow for Service request, Problem management and Change request.

Role Database Administrator

Environment/Skills

SQL Server 2005-2012, Profiler, Performance Monitor, Database maintenance, Log Shipping, Import/Export Wizard SSIS, SSAS, SSRS, Microsoft Clustering Services(MSCS).

Work Details

• Administration for very large and business critical databases in multiple SQL Instances of SQL Server 2005-2008 R2 on Four-Node cluster Active/Passive on Microsoft Windows Server 2008 R2 Enterprise Edition on SAN environment.
• Installing and migrating SQL server 2005 to SQL Server 2008 and 2008 to 2008 R2 with minimum access privileges service account to improve security.
• Handling Memory configurations for SQL Server 2008 R2 on Windows 2008 R2.
• Perform SQL Server service pack and CU patches upgrades.
• Installed, authored, and managed reports using SQL Server Reporting Services (SSRS).
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Designing and implementing comprehensive Backup plan and disaster recovery strategies.
• Configuring and troubleshooting merge replication.
• Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions.
• Implementing DR including Log shipping and Database Mirroring.

Role Web developer

Environment/Skills

PHP, CSS, JSP, AJAX, JavaScript.HTML,WAMP,XAMP, ASP .NET, MySQL, MSSQL.

Work Details

• Requirement analysis of the modules. Development of object, classes.
• Library management system - Inventory of books, Issue-reissue books, Book return, Membership, New entry.
• Online job portal - Search Jobs, Candidate profiles, apply jobs, Post new jobs.
• Online examination- Candidate profiles, Question setup, Registration number generation, Online exam and result.
• Online computer peripheral shopping - Large inventory of Computer accessories, Online purchase, create cart, Create account, order placement.
• Database structure development and SQL query optimization.
• Manual testing.