SUMMARY:

• 6+years of professional experience in Database Administration, Design, Development and Support of SQL Servers various versions in production and development environments. Experienced in using modeling tools such as ER, UML.
• 6+ experience in MS SQL Server Performance Tuning, Query Optimization, Client/Server Connectivity
• 7+ experience in collaborative tools developing administering and optimizing such as SharePoint, Sametime, Confluence.
• 6+ years of administering windows 2000/2008/2012 servers.
• 5+ Years’ experience in MS Business Intelligence solutions SSIS, SSAS, SSRS.
• 7+ years - in system study, design, development and implementation of applications and Client/Server technologies.
• Highly proficient in SQL, Transact SQL including writing queries, stored procedures, functions and triggers.
• Thorough knowledge Data Modeling concepts including Dimensional Modeling.
• Extensive experience in windows administration, active directory, DNS, DHCP.
• Cloud technologies experience with Azure and GCP. Familiarity with Microsoft Azure
• Knowledge on Azure SQL Database Migration and migration to Azure VM. Knowledge in migration tools like Azure portal, SSMS, SQL migration wizard, data migration assistant, Azure storage explorer
• Certified Information Technology trainer

TECHNICAL SKILLS:

Operating Systems: Windows, Ubuntu, Fedora

Server: Windows 2000-2012, Linux, Unix, Apache

Languages: SQL, CSS, HTML, JavaScript, C#, .NET Framework, C, C++, VB6, PHP, R

Collaborative Tools/Content Management: SharePoint, SameTime, Confluence, Drupal, Joomla, Jira, Yammer

Data Warehouse Tools: SSIS, SSRS, SSAS, Power BI, Tableau, Crystal report, Informatica

Databases: Access, SQL Server 2008 - 2016

Other Tools: Azure, Google Cloud, Citrix, Office 365, Visio, MS Project, JUMP, SAS, SAP

PROFESSIONAL EXPERIENCE:

Business Intelligence Analyst and Database Administrator, Silver Spring, MD

Confidential

Responsibilities:

• Installed, configured and managed MS SQL Server 2016/ 2014/2012/2008 R2.
• Implemented database refresh using SSIS packages and automated backup/restore jobs.
• Migrated contents from MS SQL server 2005 to MS SQL server 2014.
• Applied 2014/2012/2008 R2 periodic service packs and hot fixes (cumulative updates).
• Load data from flat data files into SQL Server 2012/2014 and 2016 database tables using bulk insert/bcp.
• Audited databases for user’s transaction, login and database action and fixing orphaned users.
• Managed users and logins in SQL server, provide appropriate server/database roles, map them to specific securable objects.
• Analyzed, deployed scripts and packages in prod/test environments from different developers based on change request.
• Involved in capacity planning and allocation of resources for databases by assisting application teams in creating databases depending upon the criticality of current and best practices in accordance with SLA of the company.
• Created and monitored database maintenance plans and schedule jobs using SQL Agent/Maintenance plan.
• Scheduled integrity check, reorganize/rebuild indexes, update statistics, backup/restore and cleanup job history.
• Analyzed Locks, Blocking, Dead Locks, Resource Utilization, and handling of Isolation Level and Concurrency issues.
• Configured database high availability techniques like Always On (HADR), Replication, Clustering as well as implmented disaster recovery techniques like database mirroring and log shipping.
• Monitored SQL Server Error Log, Windows Event Logs, Profiler, Query Execution Plan, Database Tuning Advisor.
• Build various kinds of reports using SQL Server Reporting Services (SSRS): parameterized, ad hoc, drilldown.
• Publish reports to SharePoint instance and create Web Parts in SharePoint, generated from SSRS and Excel.
• Train clients on T-SQL, database administration, SharePoint and business intelligence.

Confidential

Database Administrator

Responsibilities:

• Installation of MS SQL Server enterprise on Clustered Production, Test and Development boxes.
• Regularly monitor the performance of server using SQL Profiler, Performance monitor, Dynamic Management Views.
• Administering login id, passwords and roles creation in production and non-production environment.
• Set up transactional and snapshot replication among SQL Server 2008/2012 boxes.
• Auditing stored procedures for optimization and improving performance.
• Backing up system and user databases and restoring them when necessary. Schedule the jobs for the Database Maintenance.
• Re-align the database structure for performance and space management.
• Run DBCC commands to check the database consistency and shrink the databases.
• Extensively used DMV, SQL profiler and performance Monitor, and Performance Dash board.
• Maintain index rebuild and re-organize indexes periodically.
• Transfer data among SQL boxes using SSIS, BCP, and Back up restore. Generated reports using SSRS and Crystal reports
• Created Alerts and Notifications for system errors, insufficient resources, fatal database errors, hardware errors, security breach-technical guidance, task assignment and tracking. Provided 24/7 technical support and monitoring.
• Conducted 10+ software deployments such as O365 (cloud Azure Hybrid environment), Sametime, SharePoint 2016.
• Installed, configured, administered, created awareness, on collaborative tools such as:
• Quick Place, Sametime, Confluence, SharePoint 2013 and 2016.
• Administered Windows 2008/2012 servers. Worked on Active directory, backup and DHCP, DNS.

Programmer Analyst eVentive

Confidential, Chicago

Responsibilities:

• Managed SQL Server 2005 Reporting Services environment, Generated reports and automated spreadsheet reports
• Initiated programming and formulas to provide solutions to user requests; participated in SDLC (requirement analysis, feasibility study, design, development, testing and documentation) of new software for a travel & tour company.
• Developed an application with programmers and analysts to create Business Objects written in J2EE
• Developed software using Java, WebLogic, Stratus and SQL Server.
• Provide support for off shore companies; outsourced work, located in US.