Over the last 13+ years of Database Administration / Database Architect, I have designed and deployed multiple solutions based on Microsoft & Oracle technologies, primarily SQL Server 2005 to 2019, MySQL, Postgres and Oracle 9i/10g/11g.
Installation, configuration and upgrading of Microsoft SQL Server, Oracle & MySQL related products.
Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.
Strong technical background along with the ability to perform business analysis and write effective documentation and specifications.
Maintained and Implemented HA/DR Solutions such as full & point in time recovery, WSFC, Always-on, replication and mirroring.
Evaluate MSSQL features and MSSQL related products.
Expert in data transformation services and Bulk Loads with SSIS and BULK INSERT ETL operations.
Expert in Database migration and up gradation from MS SQL Server 2000 to MS SQL Server 2005, MS SQL Server 2005 to MS SQL Server 2008, and MS SQL Server 2008 to MS SQL Server 2019.
Establish and maintain sound backup and recovery policies and procedures.
Take care of the Database design and implementation.
Manage internal SQL Server databases, from planning and testing stages through implementation and support.
Implemented the new SQL Server 2012 mechanisms like data compression, online indexing, Contained Databases, security principals
Oracle Forms and Reports 6i to 10G,11G
Experience in Disaster Recovery Planning and Security Management operations
Experienced in Linked Servers between SQL Server 2008 R2 & Oracle 9i and 10g.
PLSQL (SPs, Functions, Triggers, Packages)
IIS Administration and management
Dot Net framework development and management
Microsoft Dynamics AX Support & administration
Excellent T-SQL Programming skills, Execution Plan, query optimization & performance tuning. Used SQL Profiler, Performance Monitor and DBCC Commands.
Oracle 11g Database cloning.
Oracle 10g and 11g RMAN backup and recovery implementation.
Oracle database migration from 11g to 10g and 10g to 12C
Experienced in Oracle archiving and flashback features
Oracle 11g database architecture designing.
Expert in ORACLE Database Administration including planning/implementing backup/recovery strategies using RMAN and without RMAN
Expertise in installation and configuration of Oracle and large databases on Linux Operating System.
Creating and maintaining logins, synonyms and access privileges using roles, controlling access to the database using operating system and Oracle security features.
Experience in Logical and Physical Design of Databases for OLTP and Data Warehouse.
Expertise in Security Issues such as creating logins and granting permissions on various objects as well as Administering security for servers logins regularly (Windows and SQL Accounts) and guest user logins.
Proficient with SQL Enterprise Manager, SQL Query Analyser, scheduling jobs with SQL Server Agent, SQL Profiler, restoring full, differential, and log backups.
Handling Memory configurations for SQL Server 2012/14/16/17 and SQL Server 2008R2 on Windows 2012.
Setup and maintain documentation and standards.
Plan growth and changes (capacity planning).
Experience in Using Performance Monitor/Profiler to resolve Dead Locks/Long Running Queries and experience in resolving System Hardware bottlenecks.
Familiarity with SSIS, SSAS, SSRS;
Informatica: Package deployment, migration and troubleshooting errors.
BizTalk: code deployments
Cherwell Ticketing System: Creating and maintaining change management system.
Autosys: create, update, maintain and troubleshoot autosys job schedules.
Rubric: create, update, maintain and troubleshoot sql server backups using rubric.
24 X 7 Production Database on Call Support
Troubleshoot performance problems, fine-tuning of databases and index Analysis.
Work on building queries, stored procedures, Crystal reports and etc. that meet business needs.
Working with SQL Server DB support Group and Provide Admin services as well.
Good Knowledge in operating third party tools efficiently like Toad, Red-Gat, PL/SQL Developer, SQL Developer, Oracle Enterprise Manager (OEM), and Ervin.
Manage and maintain Amazon AWS and cloud computing.
Manage and maintain Microsoft Azure Cloud Services.
Other duties as required and assigned