SUMMARY:

• Over 8 years of experience in Database Development, Design, System Analysis and Support of MS SQL Server 2008/2005/2000/7.0
• 3 + yrs experience as SharePoint Administrator (MOSS 2010, 2007 and WSS 3.0) as gathering Requirements, Setup, Installation, Configure and Deployment.
• Responsible for Requirements, Architecture, Infrastructure Set up and implementation of web application for product sites that provides services for globalization, and error handling.
• Promoted to SharePoint Administrator maintaining entire Intranet and Extranet environment with all department sites. Background knowledge includes project coordination, load balancing (with the help of Network Engineer) and site maintenance.
• Created and maintained knowledge base documentation for MOSS 2007 installation, maintenance, and manuals. Maintained security and permissions to control access to MOSS and other related environment
• Good experience on content organizations and Enterprise Content Management (EMC) migration.
• Knowledge on Active Directory and IIS configuration.
• Good knowledge of Relational Database Management Systems (RDBMS)
• Strong experience in installation, administration and maintenance of databases on SQL Server 2008/2005/2000 in standalone as well as MS clustered environments
• Proficient with SQL Enterprise Manager, SQL Query Analyzer, creating and scheduling jobs, alert and operators with SQL Server Agent and SQL Profiler
• Performed database health checks using SQL profiler, Activity monitor and performance counters
• Expertise in implementing efficient Disaster Recovery Strategies and High availability like Snapshot, Transactional and Merge Replication, Log shipping, Clustering (Active/Passive) and Database Mirroring
• Proficient in performing DBA tasks including installing and configuring SQL servers and backups/restore and recovery of databases
• Good team player, strong interpersonal and communication skills combined with self - motivation, initiative and the ability to think outside the box

TECHNICAL SKILLS:

SharePoint Administration: Moss 2010/2007, WSS 3.0, IIS 7.0, Active, Window Server 2008/2003, PoweShell Scripting, Axceler Control Point, SharePoint Designer 2010/2007, WSP Builder, TCP/IP and Networking, ForeFront TMGDatabase: RDBMS, SQL Server 2000/2005/2008, MS Access

Languages: C language, T-SQL

Operating Systems: Windows NT/98/2000, DOS, Windows Server 2003, Windows Server 2005

Web Technologies: HTML, ISS, and XML, XSLT, Dream weaver

PROFESSIONAL EXPERIENCE:

Confidential, NY

SharePoint Admin/SQL

Responsibilities:

• Suggest and define the Physical Architecture, Physical Architecture for SharePoint Server 2010.
• Precheck validation for Environment, Licensing for Migration on SharePoint Server 2010.
• Define the Strategy and Prepare Test Environment for Database Attach method.
• Performed the Load Balancing using Clustering in Windows Server 2008.
• Install and configure the SQL Server 2008. (Clustering done by SQL Team)
• Used Central Administration to perform server operations and application management tasks including creating and extending web applications and creating site collections.
• Resolve the issues for Migration. Support Post Remediation Efforts.
• Configure the SharePoint Server 2010 using Kerberos Authentication.
• Crated customized forms and workflows using the SP designer 2010.
• Create the Material for Site Collection Administrator and End Users.
• Automated Backup & Restore Using STSADM and Powershell Command line as well as SQL Backup & Restore using the Batch file during night time.
• Maintained security and permissions to control access to SharePoint 2010.
• Designed the tables with indexes, primary key and foreign key constraint
• Created maintenance plan for consistency check (DBCC) and maintained Index statistics of Database Application
• Developed SSIS Packages that loads data files, extracted from SAP and Oracle DB, into SQL database with necessary transformation
• Responsible for the maintenance, enhancements and troubleshooting of SSIS using Business Intelligent development studio
• Perform performance tuning, optimization, Bug Fixing and Enhancement during the various quality assurance testing cycles and for the Production dash board report
• Manage day-to-day project activities and lead the different tasks in order to meet the end user/dead line requirement
• Performed DBA activities such as daily backup and failover restore of database, monitoring/scheduling jobs on different production servers
• Handling installation and creation of new instances of SQL server databases, Managing user creations, assigning roles, security to SQL databases
• Created data flow model using MS Visio

Environment: SQL Server 2008 R2, SQL Server 2005, Excel, T-SQL, Windows Server 2003/2008, SharePoint 2010/2007, Powershell

Confidential, NJ

SharePoint Administrator/SQL Server

Responsibilities:

• Precheck validation for Environment, Licensing for Future Migration on MOSS 2010 and Project Server 2010. (Complete the Remediation and Prepare MOSS 2010 for Business Portal).
• Configure the SharePoint Foundation 2010 (Intranet/Extranet) and MOSS 2010 (Enterprise Intranet) environments.
• Configured Extranet/Intranet Environment using Claim based Authentication for SharePoint Foundation 2010.
• Actively involved to design the SharePoint Infrastructure of Different Environment.
• Develop Information Architecture for Enterprise environment, and Document management system for GSM department.
• Crated customized forms and workflows using the SP designer 2010.
• Work with Business People to Implement Customized pages, Create Custom Workflow, Content Types Using SharePoint Designer.
• Develop SharePoint Intranet governance policies, navigation, standards.
• Develop Information Architecture, remediate Site Hierarchy.
• Create the Material for Site Collection Administrator and End Users.
• Develop SharePoint Groups, Enforce Custom Permission to each group.
• Develop Security Standards for SharePoint Group Owner, Curator, Members, and Visitors.
• Work with ticketing system support team to troubleshoot and resolution issues.
• Troubleshoot third party tools issues with their support team.
• Perform Backup & Restore Using STSADM Command line as well as SQL Backup & Restore.
• Add File Supports in SharePoint Search Center ( eg, PDF, .EXE)
• Maintained security and permissions to control access to MOSS 2007.
• Deployed SharePoint 2007 - Solution Packages, Custom Web Parts, and Features using STSADM tool
• Managed Site Quota templates, config dbs and content databases for web applications using central administration client
• Lockdown SharePoint Designer, Revoke CEWP as per Client governance Policies.
• Used Central Administration to perform server operations and application management tasks including creating and extending web applications and creating site collections.
• Installed and maintained multiple SQL server 2008 instances in non-production (test, staging) environments
• Modified existing SQL architecture in order to increase performance of reporting application
• Designed the database and table structure and data partitioning and indexes for optimum query performance
• Created several tables, views using SQL Server management studio, based upon the functional specifications
• Hands on experience in developing stored procedures for complex queries for better performance, views for controlled access to data and triggers for data access audit purposes
• Performed daily tasks including backup and restore by using SQL Server Management Studio
• Setup profiler traces to support trouble shooting activities in QA environments

Environment: SharePoint 2007/2010, SQL Server 2008, Windows 2003

Confidential, NJ

SQL Server Developer

Responsibilities:

• Involved in migration of database from MS SQL Server 2005 to SQL Server 2008
• Evaluated data storage considerations to store databases and transaction logs, Optimized the physical disk performance through RAID-1, RAID-5 levels for fault tolerant database partitions
• Involved in Data Modeling, creation of logical physical data models
• Worked closely with business users in source data analysis, design and development of SSIS packages to load the data and transferred data (ETL) to data warehouse environment using SSIS
• Worked in the development of complex Stored Procedures, Triggers, functions, DTS packages to support multiple business applications. Developed and maintained Stored Procedures using T-SQL.
• Worked extensively in tuning and optimizing the performance of production databases by creating new indexes and re-writing SQL queries to utilize indexes
• Worked with Snapshot & Transactional Replication between SQL Server databases
• Participated in Test Plan, test case review meetings and Supported QA activities
• Extensive experience in trouble shooting of client connections, viewing error log and applications
• Maintaining the database consistency with DBCC at regular intervals and by re-indexing table
• Created, designed and deployed drill down reports using MS SQL Server reporting services (SSRS)
• Closely worked with Data architect, system architects, software architects, design analysts, and others to understand business or industry requirements
• Involved in administration, performance analysis, and production support for large (VLDB) databases up to 1 TB

Environment: SQL Server 2008/2005, Windows 2003, SSIS, ASP.NET, MS Access, T-SQL, MS Visual Source safe

Confidential

Intern/SQL

Responsibilities:

• Installation and configuration of SQL Server 2000 on Window 2000 OS
• High level of expertise in implementing different types of Replication Models such as Transactional, Snapshot and Merge Replication and failover clustering
• Managing of database objects like Tables, Views, Indexes etc
• Maintained login and user management in SQL Server database by managing of users including creation/alteration, grant of system/db roles and permission on various database objects,
• Managing backup and restore export and import
• Developed DTS packages to transfer the data between SQL Server and other database and files
• Well experienced with tools like Query Analyzer, SQL Enterprise Manager

Environment: MS SQL Server 2000, Windows 2000, Win NT v4, MS Access, T-SQL, DTS, UNIX