Hilton D.

Hilton D.

Database Administrator

Hyderabad , India

Experience: 7 Years

Hilton

Hyderabad , India

Database Administrator

24314.5 USD / Year

  • Notice Period: Days

7 Years

Now you can Instantly Chat with Hilton!

About Me

Seeking a position where I can effectively contribute my skills and enhance my knowledge in the environment which is creative and challenging. A result-oriented IT Professional with around 6yrs. of practical experience in IT Industry with strong unde...

Show More

Portfolio Projects

Description

  • Migrated environments (includes App and Data tier servers) from on-prem to on-prem and on-prem to Azure Cloud for Microsoft applications such as Team Foundation Server (TFS), CodeFlow, Symbols, reSearch, CodeBox and APIScan.
  • Worked on Microsoft third party application Perforce on P4 patching, P4 replica configuration, P4 Checkpoint and restore process and journal file synchronization.
  • Worked in a project to decommission 400+ servers which includes VMs and Physicals that were on end of life (EOL) SAN and released 700TB of space resulting in billion dollars savings.
  • Worked on configuring application instance in IAAS environment in a new Software Defined Networking which required extensive planning and co-ordination with DSRE (Security) teams.
  • Regularly scan Azure Advisor and make recommended changes to improve service availability and cost saving.
  • Responsible for remote coordination of on-prem and Azure infrastructure planning and implementation and worked closely with Capacity manager.
  • Create necessary documents with attention to quality and adhere to the account specific process.
  • Altered existing powershell scripts for customization. Deployed scripts on production and worked with Kusto query language and fetched reports in PowerBI.
  • Handling Live Site Incidents (LSI)
  • Service Improvement (SIP) Analysis and Implementation
  • Prepare and provide Knowledge Base for the New joiners and Tier-2 Team
  • Facilitate the hiring for the project and participate as Technical Panel member during TCS walk-in drives.
  • Azure IAAS Infrastructure Design, Planning and troubleshooting issues related to Compute, Storage and Networking resources) includes VNET creation, Internal Load Balancers (ILB), Azure Traffic Manager Profiles.
  • BCDR Testing
  • Having hands on in configuring SQL AlwaysON in data tier servers.
  • Server Statistics reporting, Security Management of Server, Patch Management, Server Services management, Managing File permission
  • Handling Live Site Incidents (LSI)
  • Providing Level-2 and Level-3 technical support in a Service Now ITIL environment
    Worked in MS Azure SQL troubleshooting and performance tuning.
  • Experience in Microsoft SQL Server database backup recovery & restore.
  • Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability and security.
  • Ability to identify and troubleshoot SQL Server issues related to CPU, memory, I/O, disk space.

Show More Show Less

Description

  • Installing and configuring SQL Server 2012, 2008R2, 2008.
  • Upgrading SQL SERVER from 2000/2005/2008 Side-by-side and In-Place upgradation
  • Applying SQL Server patches and Service Packs during the maintenance window
  • Monitoring and troubleshooting database log files and data file issues like space constraints, corruption issues.
  • Rebuilding the indexes at regular intervals for better performance
  • Creating logins, users and granting permissions as per request.
  • Handled the migration of SQL Server databases between instances.
  • Monitoring the job failures and troubleshooting them
  • Monitoring/Maintaining HA options used in servers like Log Shipping, Clustering and DB mirroring.
  • Performing SQL server daily health check and preparing a report based on it.
  • Checking the status of backup, troubleshooting the failed backups and restoration of databases.
  • Co-ordinated with team leads and managers involving in client calls for requesting downtime for server patching etc.,

Show More Show Less

Description

  • SQL Server installations and configuration.
  • Applying SQL Server patches and Service Packs during the maintenance window
  • Monitoring Log shipping and troubleshooting errors.
  • Worked with databases during crash situations.
  • Prepared presentation for teams on sessions.
  • Continuously monitoring and updating the Backup & Recovery and monitoring scheduled jobs of backup and restore procedure for database.
  • Worked with Sr. DBA for Database Administration Jobs like Security & User Admin, Job Scheduling & Notification, Database backups & Restoring.
  • SQL Server2005, 2008, 2012 installations, configuration and security settings for stand-alone servers.
  • Applying the latest service packs & hot fixes.
  • Creating logins, users and granting permissions as per request.
  • Handled the migration of SQL Server databases between instances.
  • Reviewing SQL Server and SQL Server Agent Error Logs.

Show More Show Less