Database Administraor Resume
UsA
Professional Summary
- Over 10 years of IT experience and Technical proficiency in the SharePoint Technology & Database Administration teamed with Database Creation, Configuration, Capacity Planning Optimization , Migration, Backup and Disaster Recovery Plan, Replication and Remote Database administration,
- Over 7 Years of experience in installing, configuring and maintenance of SharePoint 2010 & MOSS 2007 at enterprise level. Solid experience in Configuring/analyzing/tuning Search Functions (SP2010 & MOSS 2007).
- Over all 3 years of experience in Visual Studio Team Foundation Server Implementation & Administration.
- Solid experience in creating Web applications, Site configuration, sub-sites, SSP’s, setting up Server Farms.
- Good experience in developing/modifying custom Webparts, lists , workflows and InfoPath forms
- Expertise in Configuring, Administrating of MS SharePoint Server 2010, 2007 farms and troubleshooting SharePoint security, Site collections, Sites, Sub-sites, Lists & libraries.
- Good experience in implementing and configuring various SharePoint authentication models through Active Directory like NTLM, Kerberos and Forms Based Authentication.
- Hands on experience with STSADMIN command line utility & PowerShell Scripting for initializing, deploying and activating the features/solutions as well automating the SharePoint backup jobs and windows services administration
- Expertise in configuring Search Indexing and Query services for Search on SharePoint 2010 and also experience configuring the SSP’s on MOSS 2007.
- Creating and managing Records Management Solutions. Implementing Policies and configuring Information Rights Management.
- Implementing, configuring and managing different service applications like Excel Services, Access Services, BCS, User Profile service, Performance Point & Web analytics on SharePoint 2010.
- Managing Web parts and Site Content types, Perform routine maintenance and support activities. Working knowledge with SharePoint Search and Indexing at the Enterprise level.
- Perform backups of SharePoint systems and backend SQL databases. Solid experience in configuring SharePoint Farms in 2010 and MOSS 2007 versions.
- Sound knowledge in SQL Server Performance Monitoring, Troubleshooting and Problem resolution.
- Experience in implementing enterprise wide backup/recovery solution for MS SQL Server 2008 & 2005 environment.
- Experience working with Storage Area Networks (SAN) in a large enterprise environments.
- Experience working with Change Management team on initiating maintenance activities for patch update / security updates etc., on Pre-production & production servers
- Knowledge on configuring and monitoring of FAST search for SharePoint 2010
- Experience working with SharePoint Designer 2007 & 2010
- Ability to consult with application software owners, project managers, external vendors and IT development team and apply change management, version release, integration and replacement of new application software and modules, and skills to influence business IT choices within the organization.`
- Solid team player with exceptional leadership, interpersonal and communication skills.
- Ability to enhance an effective, responsive relationship between application software owners, project managers, external vendors and IT development team.
- Good working knowledge of Windows server 2008, 2003 and its versions, NT, OS, Windows XP & other latest technologies.
- Good understanding of MS SQL Server standards and best practices
- Capable of developing technical documentation and presentation. Excellent oral/written communication, interpersonal and presentation skills.
Technical Expertise:
Applications
Microsoft Office SharePoint 2010 & 2007
- Site, Content & Security Management
- Document & List Administration
- Template & Layout Design
Microsoft InfoPath 2007, 2003
- SharePoint (web-based) Integration
- Complex Logic & Validation
- Multi-part (Smart) Form / Layout Creation
Microsoft Visual Studio 2005 & 2010
- C#/C++ Review & Problem Solving
- VB.NET Review & Problem Solving (some coding)
Microsoft SQL server 2005 & 2008 R2
- Complex Query Syntax
- Store Procedures & Triggers Maintenance
- Performance Monitoring
Microsoft Windows Active Directory Administration
- Installation and Configuration
- Trees, Forests and Domain user accounts Maintenance
Deployment
Microsoft Windows Vista, XP
- Installation & Configuration
- Support & Troubleshooting
Microsoft Windows Server 2000,2003, 2008 R2
- Virtualization
- Change Management
- Server Farm Architecture Management
Microsoft Hyper-V Server configuration and implementation
VMware workstation 7.0
Microsoft Active Directory
- Domain Controller Installation
- Multi-domain Management
- Security Group Architecture and Administration
Microsoft Internet Information Services 5/6
- Site Management
- Application Pool Administration
- Security
Microsoft SQL Server 2008, 2005 & 2000
- Server/Client Architecture
Microsoft Exchange / ActiveSync
- Installation & Configuration
Microsoft Forefront Threat Management Gateway
- Installation, Configuration & Maintenance
Avepoint DocAve 5.5.2, 5.5.3, 5.4 & 5.6
- Installation, Configuration and Maintenance of different modules
- Expert in Data Protection, Administration and Deployment modules
Education
Masters in Human Resource Management
Bachelors in Computer Applications
Expertise:
Databases : MS SQL Server 2000, 2005 & 2008 r2
Database tools : SQL Profiler, SQL Query Analyzer, Replication server, SQL Agents, SQL Alerts, SQL Jobs, SQL Mail
Scripting Languages : VB Script, PowerShell scripting
Programming languages : .NET Framework 3.5, MS T-SQL, C#.Net
Server Tools : Virtual Server R2, HyperV, VMware
Development Tools : Visual Studio 2008 & 2010
Web Technologies : ASP.net, HTML, DHTML, CSS, XML, XSLT, IIS
Operating Systems : Windows Server 2000, 2003 & 2008 r2, Windows NT Server 4.
Version Control Tools : Visual SourceSafe 6.0 admin, SVN Tortoise, VSTF 2005/2008(Team Foundation Server)
Tools used : MOM 2005& SCOM 2007;
Networking : DHCP, DNS, Forefront TMG, Site Minder, ISA Firewall etc.
CRM: Seibel CRM, Microsoft enterprise
Microsoft Forefront Threat Management Gateway
Certifications:
Microsoft Certified Technology Specialist (MCTS) SQL Server 2005 Implementation & Maintenance
Microsoft Certified Technology Specialist (MCTS) Microsoft SharePoint Server 2007 Configuration
Professional Experience:
Project Name : SharePoint Global Team, Sept 2011 Till date
Confidential,Chicago IL SharePoint AdministratorRoles & Responsibilities:
- Build SharePoint 2010 Infrastructure for the upgrade projects.
- Successfully completed 2010 upgrade project for Intranet site and working towards Extranet & Internet Portals.
- Troubleshoot WFE’s, Application & FAST search servers.
- Troubleshoot Problem tickets assigned by the IT Service Desk Team.
- Develop Rollback plan in case of updates & patch installations.
- Developed Disaster recovery plan for the farm in case of any failure.
- Coordinate with DBA Team and Windows teams on Database and Windows administration activities
- Work with Network and Information security team on Network and security issues
- Plan & Design for the SharePoint 2010 upgrade.
- Troubleshoot Disk space alerts & several other Windows errors related to SharePoint servers thrown by the SCOM system.
- Implement Web Application security changes on different environments.
- Work with Application vendors on installing there products for the client and having the applications available for business users for their needs.
- Implement changes at the Technology level to meet the business requirements.
- Design and plan DR Strategies.
- Experience working with Site Minder, F5 Big IP, use fiddler for troubleshooting issues etc.,
- Experience working with NewsGator Social Sites & Idea Module versioning 2.0,2.1 & 2.6
- Experience implementing Custom Claims authentication, NTLM and FBA authentication for SharePoint 2010 sites.
- Experience administering AvePoint DocAve jobs.
Project Name : ISV Systems April 2011- Sept 2011
Confidential, Omaha NE
SharePoint AdministratorRoles & Responsibilities:
- Troubleshoot Incident tickets raised by the Lincoln Users
- Coordinate with DBA Team and Windows teams on Database and Windows administration activities
- Work with Information security team on Site access / security issues
- Prepare Knowledge Base articles, .ppt’s and provide documentation on several end user activities, as & when required
- Experience working with Powershell on automating the process for SharePoint backups at Site collection & Web Application level and also automate several other admin tasks
- Troubleshoot Disk space alerts & several other Windows errors related to SharePoint servers thrown by the SCOM system.
- Experience working with Migrating the sites from WSS 2.0 to SharePoint 2010 as well as from MOSS 2007 to 2010
- Experience working with third party tools for Migration of sites from MOSS 2007 to SharePoint 2010 and use of Axceler ControlPoint for producing SharePoint administrative reports and use of AvePoint - DocAve 5.6 for more granular level of Application backups and Data Protection suite in case of Disaster.
- Experience working with Nintex Workflows & Axceler ControlPoint for more robust administrative reporting capabilities.
- Experience working with SharePoint Designer 2010
- Established a plan for enabling the services and features to Lincoln users considering the governance and Lincoln policies & procedures.
Project Name : SharePoint & TFS 2010 Upgrade Jan 2011- April 2011
Confidential,Richmond, VA
SharePoint 2010 Architect/ AdministratorDay to Day Activities:
- Administration of the TFS system for developer access and code migration from VSS
- Manage Team projects, automated builds, plan and execute recovery/backup procedures.
- Creating and managing TFS project branches to include source code repositories for applications
- being migrated into TFS
- Create and manage TFS SharePoint sites, and Reporting Server capabilities.
- Creating and maintaining TFS reports to be used for tracking resource utilization and capacity,
- Defects and enhancements, product manifests, product aggregated reports for executive
- Dashboards and other reports to be defined
- Ensure proper labeling and branching strategies are enforced.
- Ensure SDLC process policies are enforced within TFS
Apart from the day to day tasks following are the additional responsibilities duly assigned
- Current state assessment on the existing MOSS 2007 and TFS 2008 implementation
- Meet with the Stakeholders and other IT Managers, to discuss on the approach for the upgrade of
- SharePoint and TFS environments
- Document the challenges, risks and issues found in the current environment and come up with a
- Strategy to fix the issues where the risk level is categorized on different factors
- Have worked with other business consultants on the implementation of SharePoint and TFS 2010
- Technology
Project Name : Providence Oregon Publishing portal Nov 09 Jan 2011
Confidential,Portland, Oregon
SharePoint technologies:
Microsoft Office SharePoint Server 2010, Microsoft Search Server 2010
SharePoint server: associated technologies:
ASP.Net installation and troubleshooting ,Virtualization Hyper-V, Automation with XML, VMware virtualization
SharePoint database:
SQL Server 2008 r
Operating Systems:Windows Server 2008 r2
Development Tools:Visual Studio Team Foundation Client 2005/2008
Web Technologies:ASP, HTML, DHTML, CSS, XML, XSL, IIS 6.0
Version Control Tools:SVN
Tools Used:Microsoft Forefront TMG, SCOM 2007, Avepoint DocAve for Backup and restore, Google Analytics for studying and analyzing the site usage from different regions and reporting purpose
Roles & Responsibilities:
- Being the only SharePoint administration I have been involved at every stage of the project i.e from Planning, designing, implementation and maintenance.
- Experience in building Dev, QA, Staging and Production environments with the required specifications according to Microsoft standards and replicating the content from QA to staging and Staging to production.
- Expertise in AD security implementation and configuration, IIS 6.0 and Forefront TMG (ISA) 2010
- Designed and implemented Backup, restore & disaster recovery procedures.
- Installed, Configured and Implemented Microsoft Forefront TMG for web proxy widows authentication model
- Implemented Failover model at SharePoint application level as well as at the Database level
- Designed Disaster recovery (DR) model at the site level taking Microsoft best practices into considerations
- Expert in working with Midsized and Large size enterprise topology environment
- Installed and Configured SCOM 2007 with SharePoint 2010 patch for monitoring Application, Database and disk space alerts
- Implemented Incident, Production, Change, Configuration and Release management following the ITIL best practices
- Simultaneously worked on multiple other sub projects - migration of sites from MOSS 2007 to SharePoint 2010 technology and Maintenance of MOSS 2007 internet site
My day to day responsibilities are as follows:
- Creating AD User accounts as and when requests are received
- Deploying solutions using STSADM command line utility tool, activating the features and adding web parts
- Troubleshooting deployment issues, performance issues, application connectivity issues, Database connectivity issues etc.
- Planning and scheduling of security upgrades and patches.
- Creation of sites, pages, List libraries, master page templates, user training documentation etc.,
- Maintain and administer SHAREPOINT 2010 application services such as Metadata service, Excel Services, Search Services, User Profile Service application, Excel services and BCS for Reporting needs.
- Monitoring Network, Database, application level alerts and taking appropriate actions to resolve the alerts
- Analyzing the event viewer logs, application logs in case of any issues at the application front, DB level or at the O/s level.
- Taking Farm, Site or list level backup and restore the sites using DocAve Administration module in 5.5.3. Also used DocAve Replicator for replicating the sites and its content from QA to Staging; Staging to Production etc., used Migration module for migrating the sites within the same farm or another from MOSS 2007 to 2010.
- Apart from the above, I have implemented ITIL frame work as the support model for our Production environment. Trained the offshore team on SharePoint Farm topology, Architecture that I have implemented for Providence project and how to troubleshoot the low severity issues.
- Deployed third party web parts in SP2010 environment
- Working knowledge on integrating SharePoint application with other relational databases like Oracle, MS Access using BCS / BDS
- Prepared documentation on the Business SLA’s, Escalation procedures and on ticketing system
Environment: Windows Server 2008 R2, Hyper-V Virtualization, VMware workstation for QA environment, SQL Server 2008 r2, Oracle, MS Access, Microsoft Forefront TMG, Bug Tracker tool, DocAve 5.5.3, SharePoint 2010, IIS 6.0, 7.1, Active Directory, Microsoft Exchange server 2010, SAN
Project Name : Business Group Centre Of Excellence July 07 Oct 09Confidential, Redmond, WA
SharePoint & TFS Administrator / Developer (Visual Studio Team Foundation Server)Project Skill Sets:
SharePoint technologies:
Microsoft Office SharePoint Server 2007, SharePoint Portal Server 2003,Microsoft Search Server 2007
SharePoint server associated: technologies:
ASP.Net installation and troubleshooting ,Virtualization Hyper-V, Automation with XML
SharePoint database: technologies:
SQL Server 2005 administration
SharePoint design technologie:
SharePoint Designer, SharePoint backup-restore tool, InfoPath Configuration Basics,
Operating Systems:Windows NT, Windows Server 2008,2003,2000, Win 7 server/Client , XP & Vista
Development Tools:Windows NT, Windows Server 2008,2003,2000, Win 7 server/Client , XP & Vista
Web Technologies:ASP, HTML, DHTML, CSS, XML, XSL, IIS
Version Control Tools:Visual SourceSafe 6.0 admin, VSTF (Team Foundation Server) 2005 & 2008
Tools Used:MS-CRM, MOM 2005 & SCOM 2007
CRM:Seibel CRM, Microsoft enterprise, Remedy
Roles & Responsibilities:
- Installation, Maintaining and administration of SharePoint servers MOSS 2007, SQL databases, IIS servers, Active Directory
- Designing, Installing and maintaining enterprise-class MOSS 2007 farm and all related processes including backup/restore, site collection administration, Internet/extranet/intranet configuration, security, and virus protection.
- Good experience in Customizing/Designing Master Page and layouts, Site templates etc., using SharePoint Designer 2007
- Experience with client side coding and building custom WebParts as per the business users requirement
- Deployment of SharePoint solutions using STSADM command line utility
- I have successfully managed Large SharePoint farms, Administered SharePoint 2K7 components such as Shared Service providers, Web applications, Site collections, Top-level sites, Sub-sites, Libraries and Lists.
- Creating & troubleshooting issues with Dashboards and Reports as per customer requirements.
- Responsible for Windows Office Server security, high-availability, and capacity planning, performance monitoring, complex troubleshooting and problem resolution of SharePoint related issues.
- Performing regular SharePoint network and security audits & manage security for all sub-sites
- Troubleshoot Web servers
- Successfully integrated MOSS 2007 with Visual Studio Team Foundation server
- Successfully customized SharePoint components like web parts, lists, web pages, workflow, InfoPath forms
- Help resolve complex product related issues with TFS development team
- Working with the incident management team to provide solutions to complex issues w.r.t to SharePoint & TFS
- Clone and split the Team foundation server as per the capacity planning
- Troubleshooting Application and Data Tier servers
- Installation, Configuration and administration of Visual Studio Team foundation server
- Building Application tier and Data Tiers
- Creating TFS projects, Migrating the Source code from one application to another (internal application to VSTF) and customizing the Project templates
- Provide TFS support to Microsoft internal customer
- Troubleshoot SharePoint related issues reported by the internal Microsoft employees, vendors and business partner
- Customization of TFS Process templates
- Demonstrate knowledge and extensive experience with SharePoint products and technologies, MS Office 2007, Windows Active Directory, SQL Server 2005, 2008, Reverse Proxies, Firewalls and Intelligent Load Balancing.
Project Name : Confidential, August 04 May’ 07
SharePoint Administrator Hyderabad, INDIARoles & Responsibilities:
- Maintaining the Clients SharePoint site permissions, providing access to users on the SharePoint site, MOSS 2007
- Maintaining systems security and integrity concerning data and computing resources and suggesting corrective actions on the MOSS site as necessary.
- Install, configure and maintain SQL server databases
- Perform database backups and refreshes
- Configuring and resolving Alerts using Microsoft Operations Manager
- Provide application support to internal customers
- Conducting trainings and technical workshops on the product knowledge
- Planning and implementing scheduled maintenance
- Solving issues with SQL Server
- Monitoring Share point portal
- Fine tuning SQL Server Reporting/analysis Services
- Maintaining and Executing Backup/Recovery procedures
- Migration of sites, Content, Lists and document libraries from WSS 2003 to MOSS 2007 and database migrations
- SharePoint portal administration
- Troubleshooting and Monitoring Databases (Performance, Replication, Log Shipping, Jobs, DTS, Security, Updating schema according to Application owners requirement)
- Managing Security and performing cleaning up tasks on the server
- Maintaining integrated security for access to SQL Server Databases, Reporting sites and associated share point portals.
Environment: WSS 2003, MOSS 2007, SQL Server 2005, Windows server 2003, IIS 6.0
Organization Name Confidential,Sept’01 July 04
Jr.SQL Server Administration Hyderabad, INDIARoles & Responsibilities:
- Management of SQL Servers, databases, storage management for databases sizing from 20GB to 50GB.
- Management of database objects such as tables, views, indexes etc.
- Management of users including creation/alteration, grant of system/db roles and permissions on various database objects.
- Involved in writing Transact-SQL command line script for various needs.
- Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to administer SQL Server. Used SQL Server System Tables to retrieve metadata.
- Voluntarily contributed for the maintenance activities done on the weekends.
- Administration and monitoring of SQL Databases.
- Ensure that the Databases are up and running all the time.
- Analyzing and optimizing MS SQL Server production databases.
- Scheduling tasks and creating jobs etc.
- Troubleshooting issues with the databases & problems reported by other teams.
- Use SSRS for the creation of team metrics reports when requested by the Top management.
ACHIEVEMENTS:
- Won the Award for Employee of the Quarter for the year 2003 at Dell.
- Won the Award of Top FTR (First Time Resolution) for the year 2003 in providing online resolutions to the clients, at Dell.
- Recipient of award from CTS Hyderabad (HDPI) for the significant efforts in assisting & providing support, thereby ensuring seamless functioning of CTS Operations in 2004.
- Based on my exceptional performance I have been promoted as a Senior Technical Analyst.
- Looking at my consistent performance throughout the year I was rated 2 during my annual appraisal.
- Appreciated by Top management for the introduction of online documentation tools.
- Received many appreciation mails from all across the GSC’s IT Managers, Business Areas, and External & Internal users for an excellent job.