Job Description :
Working on 27/7 SQL Server Production DBA support on Rotation basis
Installations and configurations of SQL servers .
Working on Service now oriented structural support from operations on SQL server issues
Worked on Design new SQL Server Installations & Configurations on Azure/AWS
Supported databases on Azure/Cloud/AWS environments
Manage all SQL backups to Data Domain/Data boost and Tivoli storage manager.
Managed 15 offshore DBA’s on day to support and manage
Managed larger size databases on Sharepoint environment
Used SCRUM tool to manage our day to day project support
Maintained the existing Production SQL Servers and Databases.
Communicating with Application owners Business teams on SQL Server requirement.
Created many SQL Server Databases.
Supported Cassandra database server
Supported Postgresql, MYSQL database servers
Worked on VM ware tools VMConverter for migrations from Linux/Unix to VMware
Working on supporting SQL Server related applications (Trading, Financial, Trust projects)
Resolved the performance issues with very large SharePoint application databases
Supported the existing databases.
Managed Jquery objects and created new JQuery objects for Microsoft .net MVC framework
Supported the SQL objects using MVC frame work with JQuery development team
Worked closely with .Net/Jquery development team to support their objects related to database administration.
Configured 3M MVS database systems
Designed and Supported 3M MVS systems
Worked on SQL Server Reporting services
Working on Regular production SQL Server maintenance jobs, backup jobs.
Worked on SOX Security Audit related to SQL Server databases
Worked on resolving regular SQL Servers and databases problem incident tickets.
Worked on SQL Server and databases Service manager tasks to perform the activities.
Worked on Databases Backups & Recovery Planning process
Worked on Database Backup & Recovery Implementation & Testing and fixing issues
Worked on Backup Maintenance plan execution and scheduling process
Worked on Install SQL Server Instances & Database Level Security process
Worked on SQL-Server Client Installs and Database Connectivity.
Worked on Database data files, log files, backup files and trace files Space Management
Worked on database Document Intent and Expectations
Worked on Security process using database scripting, windows scripting and VB scripting
Worked on Database Application Object Planning, Object Creation
Worked on Database Application Access & Performance Planning
Worked on Database application usage trace files Profile Planning and creation
Worked on Database Application Security Planning (Roles) and creation of Database User Accounts(ID’s) Assigning of Roles to User Accounts
Worked on database Application Security Implementation
Worked on Database Application Client Software Deployment
Worked on Database Application Migration/Upgrade Planning and implementation
Worked on database Application Migration/Upgrade Code/Script Creation/Test
Monitor Database Uptime per Requirement (7x24etc)
Worked on Monitor and Inform Application Owner of Perf. Issues
Worked on database tune Instance Parameters for Performance Issues
Worked on database tune Database Parameters for Performance Issues
Worked on Database Maintain reasonable History (Quest PA) for Trend Analysis
Worked on Document Database Change Control Database changes, Patches and Upgrades
Worked on database Production Database Problem Support
Worked on Power BI tools and machine learning tools to admin and development data ware house internal projects.
Worked on D-SQL, and Parallel Data Warehouse(PDW), Azure day to day production support
Worked on database Defect Resolution
Worked on SQL-Server Services if any issues and change SQL services passwords.
Worked on SQL Server Database execution of System Backup Processes and System Recovery process
Worked on DTS /SSIS management and execution and deployment
Worked on database maintenance jobs Creation and execution of Job requests
Data management ( statistics, indexes)
Creation of Admin User Accounts