Web Applications Servers Resume
3.00/5 (Submit Your Rating)
SUMMARY
- Highly Accomplished SQL Server D Confidential base and Oracle D Confidential base Administrator (Total Exp. 10+ years)
- D Confidential base administrator (DBA) wif extensive experience installing, configuring and supporting next - generation d Confidential base solutions in SQL Server environments and Oracle d Confidential base environments; an TEMPeffective communicator wif exceptional relationship management skills wif teh ability to relate to people at any level of business/management & significant experience working wif steering committees; Self-motivated team player wif excellent verbal and writing communication skills & ability to learn things fast and a discerning mind;
TECHNICAL SKILLS
Programming: C, C++, TSql, HTML
Operating System: WINDOWS 98|XP|2000|VISTA| and WINDOWS Server 2000, 2003, 2008 and 2012
Front-end: MS-OFFICE, MOM, Sql Monitoring, SQL Client Tools, SSCM, Management Studio, Query Analyzer, SQL Profiler, SSIS, SQL monitoring tool & OEM 11g.
Backend: RDBMS Concepts, SQL Server 2000, 2005, 2008, 2008 R2 and 2012, Oracle 9i & 10g
Others: SCOM 2012, Sql Monitoring Deployment and Administration and administration
WORK EXPERIENCE:
Confidential, TX
Web Applications Servers
Responsibilities:
- Performing a role an application Service Design Engineer, responsible for Infrastructure planning, design and maintenance required Business applications
- Involved in designing teh Infrastructure of SharePoint application.
- Installed and Configured MS SQL Server 2012, 2008/2008R2/2005
- Performed migration/upgradation from lower to higher version.
- Performing regular server health checks before starting teh business hours.
- Worked on various Recovery Models, Performing Backups & Recovery of d Confidential .
- Setup backup and recovery procedure using SQL native Backup.
- Provided End to End SQL Server Administration Support to around SQL and Web Servers.
- Designed and Implemented d Confidential base maintenance plans for various d Confidential base activities.
- Worked extensively on monitoring teh d Confidential base, checking error logs, checking teh log file size and free space in teh d Confidential drives.
- Worked on setting up log shipping, d Confidential base mirroring, SQL AlwaysOn, transactional replication and building redundancy to eliminate single point of failure.
- Experience in Performing Cluster operations, failover and failback, adding dependencies and troubleshooting.
- Worked wif other Technical Teams like Application Admin team, Server team and Network team to solve Performance and/or connectivity issues.
- Troubleshooting functional/technical issues in teh application and raising bugs wif teh Engineering team.
Confidential
Responsibilities:
- Performing a role of Primary DBA, handling about all SQL server d Confidential bases & Oracle d Confidential base.
- Identifying and automating frequently performed activities at work.
- Planning and configuring of MS SQL 2005/2008, SQL Cluster servers, SQL Litespeed.
- Tracking recurring issues and providing solutions/fixes.
- Installing and configuring Sql Monitoring (a third-part monitoring tool).
- Setting up and maintaining linked servers, replication and SQL cluster servers.
- Troubleshooting Replication, Log shipping and SQL clustering issues.
- Maintaining server and d Confidential base level user security privileges.
- Configuring and troubleshooting Service Broker and D Confidential base mirroring.
- Monitored and controlled system capacity plan for future system requirements.
- Made recommendations for space management and monitoring.
- Handled routine administration of SQL Server.
- Configured replication in SQL 2008 on test and production servers.
- Uploading report files (.rdl) in SSRS report sites and SSIS packages/files (.dtsx) to meet teh business needs.
- Working on service requests (SR) raised by users to meet their needs meeting SLAs.
Confidential
Responsibilities:
- Involved in Installing and Configuring of MS SQL 2000/2005, SQL Cluster servers, SQL Litespeed (a third party tool for SQL server backups and restores) and upgrading servers and Migrating d Confidential bases from SQL Server /2008.
- Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and D Confidential base Engine Tuning Advisor.
- Maintained server and d Confidential base level user security privileges.
- Worked on performance issues and optimized SPs and queries.
- Set up and maintained linked servers, replication and SQL cluster servers.
- Maintained teh d Confidential base consistency wif DMV and DMF’s at regular intervals.
- Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
- Involved in Troubleshooting Replication, Log shipping and SQL clustering issues.
- Responsible for creating table spaces, tables, indexes, user logins and passwords and also responsible for setting privileges.
- Set up and Monitored Backup jobs and DBA maintenance jobs using ignite tool.
- Performed regular server health checks.