SUMMARY

• I am an IT leader highly focused on security, virtual and cloud computing, constantly adopting cutting age technologies and IT best practices.
• I am an Experienced Database Architect with 15 years of Database, Systems Engineering, Project Management, IT consulting, solutions architecture and proven success as agent of change.
• Successful in enterprise strategic planning and providing comprehensive IT solutions within large complex organizations.
• My professional progression from Sr. DBA/Systems Engineer to Solution Architect has prepared me for challenging leadership roles.
• I am seeking an IT Solutions Architect Position to contribute with remarkable creativity and work ethic and will utilize strong business intelligence to increase productivity and profitability, with new challenges and opportunities to build upon my expertise.

AREAS OF EXPERTISE

• IT Best Practices.
• Building relationships
• Establishing SLAs
• Enterprise Application Integrations
• Capacity Planning and Requirements
• IT Solution's design and planning
• Progressive system/design
• Sr. Database Architect
• Sr. Systems Engineer
• NetBackup Administrator
• SharePoint Administrator
• Database and VM servers performance Tuning.

PROFESSIONAL EXPERIENCE

Confidential, Washington DC

Database Architect/System Engineer

Responsibilities:

• Installed and configured SQL Server 2012, 2008R2, SQL Server 2008, and 2005 on Windows Server 2008R2 and 2003, SQL Server 2000 on Windows 2000 advance Server.
• Automating Database tasks (Created jobs, alerts, and schedules for database maintenance tasks) using SQL Server Agent.
• Created UNIX Bash Shell Scripting using AWK & SED and executed using Crontab for database Error report email distribution.
• Install and troubleshoot client connectivity software, such as ODBC, Microsoft 2008/2005/2000 client, MS Access.
• Created SSIS (SQL Server Integration Services) packages in SQL Server 2008R2, 2008, 2005 Integration Services (SSIS) and migrated DTS packages to SSIS packages.
• Created and modified stored procedures, triggers and functions
• Performed database backups, restored database from backup, and developed recovery procedures.
• Migration - Performed database migration from Oracle to SQL Server 2008R2.
• Standby and Mirroring - Configured and Maintained Standby using log shipping and database mirroring in SQL Server 2008R2 and 2005 for high availability.
• Configured Peer to Peer replication for High Availability Solution.
• Managed all Publisher, Distributor and Subscriber database environments for replication.
• Performed performance monitoring using Customized Scripts on system tables using DMVs, DMFs, Activity Monitor, SQL Server profiler, Windows performance monitor and Database engine tuning advisor to analyze and fine tuning of long running queries, dead locks, blockings and stored procedures and slow running servers.
• Run DBCC to check physical and logical consistency of database and Rebuilding indexes.
• Reporting Services - Installed, Configured and Administered SQL Server 2008/2005 Reporting Service. Besides that managed reports and helped developers in designing and developing reports
• Security Management - Access and security management like creating Logins with appropriate roles, creating users and groups and granting and revoking privileges for data security.
• SP (Service Pack) - Applied Service Packs patch and hot fixes for database.
• Documentation - Created documentation for installation, monitoring procedures, security policies, configuration changes, migration procedures.

Solution Architect

Responsibilities:

• Implemented IT systems Infrastructure Architect with distributed systems. Guided the planning of enterprise-wide infrastructure directions based on market developments and enterprise vision.
• Established and advanced strategic direction of corporate IT systems infrastructure.
• Leaded the definition of hardware platform and technologies established as corporate standards to be used within specific initiatives.
• Worked with the vendors to minimize cost of ownership.
• Provided server infrastructure specification for various business line technologies to provide IT solutions.
• Deploy models and system sizing metrics integrating business and application requirements.
• Analyze new logical and physical functionality for integration into existing corporate IT infrastructure.
• Design and implement VMware virtual servers.
• Administrate VMware vCenter storage and planning.
• Application performance and capacity planning. IT Systems Requirements analysis and design.
• Saved $1 Mi dollar by using cheap NAZ Storage then expensive 5TB of SAN to be reclaimed.
• 500 VM virtual server design builds that replaced physical servers and Windows 2003 server remediation's that resulted in estimated $1 million dollar savings over physical servers.
• Support Applications: Web/App servers, IIS Web servers, Microsoft SQL DB and Enterprise Oracle Applications, PCI applications, and Voice and Data network applications. Also worked on deploying PCI /Security Application's and Virtual appliances.
• Technical Architect for Confidential Headquarter Datacenters and 72 field office Datacenters.
• Reviewed budget goals and saved $4 million in new hardware expenses by consolidating databases and application

System Engineering

Confidential

Responsibilities:

• Performed NBU client installations.
• Configured and managed backup systems.
• Worked with Netbackup versions 6.5 through 7.7.3
• Streamlined system backup procedures.
• Conducted daily tape management.
• Developed and implemented updated backup policies.
• Performed daily system monitoring duties.
• Assisted with new software testing and installation.
• Performed system backup duties and routine checks.
• Handled Netbackup support issues.
• Trained new members of IT team in NBU procedures.
• Configured Netbackup client properties.
• Performed and supervised NBU testing.
• Prepared daily and weekly system performance reports.
• Applied patches and performed regular system updates

SharePoint Administration

Confidential

Responsibilities:

• Creating and maintaining SharePoint features including Web Applications, site collections, lists and libraries, forms, web parts, and workflows.
• Integrated SQL server reporting services SSRS with SharePoint in Staging and Prod Environment.
• Administering the day-to-day operations of SharePoint 2010 farms.
• Writing PowerShell scripts to configure and automate routine administrative tasks.
• Providing SharePoint technical support if any issues are identified by business team.
• Experienced with SharePoint central administration and security options.
• Experienced with enterprise search, workflow and collaboration.

Windows Administration

Confidential

Responsibilities:

• Performed daily File Permissions tasks and resolved broken chain issues.
• Created SOP on File Permissions for Helpdesks.
• Troubleshoot IIS, Application Pool, Local Security Policy, and Logon as Service issues.
• Setup and maintain Windows Clusters for Database servers.
• Install & configure Maintenance, Migration and Administration of MS Windows Server 2008 & 2012 Physical and Virtual Builds.
• Proficient in maintenance, admin and support of over 70 Windows Servers and 700 workstations in current environment.
• Active Directory Services; Active Directory Group Policy Objects (GPO); Group Policy Management
• Server hardware planning & implementation, troubleshooting and maintenance.
• Sorted complex issues pertaining to hardware and network failure
• Monitored both Hardware and Software systems for errors and updated them regularly to maintain proper functioning and flow of information.
• Excellent knowledge of the process involved with decommissioning of servers.
• TCP/IP Network Troubleshooting
• Experience supporting Enterprise anti-virus, anti-spam, filtering, logging, encryption and email tracking.
• Basic knowledge of PowerShell commands and how to perform non-GUI tasks for windows AD.

Basic Lync Administration

Confidential

Responsibilities:

• Maintained and backed up Lync database.
• Account Creation for new employees
• Name Change on existing employees
• Troubleshooting Frontend Service issues
• Configured and Maintained RRSR Reporting Service Databases.
• Updating operating systems (patching). Advertising applications for user driven deployment of approved applications in application catalog
• Provide application technology and operating system support through the distribution of applications, packages, and updates.
• Provide client configuration support, building, testing, upgrading and replacing applications and packages
• Provided tier III support to Tier I & II support teams for SCCM and O/S related issues.
• Used remote control viewer to resolve client issues.
• Installation and configuration of SCOM Servers and Maintain SCOM Database
• Discover and Deploy Client to all Domain Windows Systems
• Ongoing maintenance & administration of System Center Operations Manager
• Monitor: Monitor Systems and resolve Alerts related to the Windows Systems

Environment: MS SQL Server 2012R2, 2008R2, 2005, 2000, Windows Server 2012R2, 2008R2, 2003, SAN, VMWare, SCOM, SCCM, SharePoint 2010.

Confidential, Washington DC

Lead Database Administration/UNIX/Windows/Mainframe Systems Administration

Responsibilities:

• Successfully configured, maintained, troubleshot, Created Documentation and Best practices.
• Configured Peer to Peer replication for High Availability Solution.
• Installed and configured SQL Server 2012, 2008R2, SQL Server 2008, and 2005 on Windows Server 2008R2 and 2003, SQL Server 2000 on Windows 2000 advance Server.
• Automating Database tasks (Created jobs, alerts, and schedules for database maintenance tasks) using SQL Server Agent.
• Created UNIX Bash Shell Scripting using AWK & SED and executed using Crontab for database Error report email distribution.
• Install and troubleshoot client connectivity software, such as ODBC, Microsoft 2008/2005/2000 client, MS Access.
• Created SSIS (SQL Server Integration Services) packages in SQL Server 2008R2, 2008, 2005 Integration Services (SSIS) and migrated DTS packages to SSIS packages.
• Created and modified stored procedures, triggers and functions
• Performed database backups, restored database from backup, and developed recovery procedures.
• Migration - Performed database migration from Oracle to SQL Server 2008R2.
• Standby and Mirroring - Configured and Maintained Standby using log shipping and database mirroring in SQL Server 2008R2 and 2005 for high availability.
• Configured Peer to Peer replication for High Availability Solution.
• Managed all Publisher, Distributor and Subscriber database environments for replication.
• Performed performance monitoring using Customized Scripts on system tables using DMVs, DMFs, Activity Monitor, SQL Server profiler, Windows performance monitor and Database engine tuning advisor to analyze and fine tuning of long running queries, dead locks, blockings and stored procedures and slow running servers.
• Run DBCC to check physical and logical consistency of database and Rebuilding indexes.
• Reporting Services - Installed, Configured and Administered SQL Server 2008/2005 Reporting Service. Besides that managed reports and helped developers in designing and developing reports
• Security Management - Access and security management like creating Logins with appropriate roles, creating users and groups and granting and revoking privileges for data security.
• SP (Service Pack) - Applied Service Packs patch and hot fixes for database.
• Documentation - Created documentation for installation, monitoring procedures, security policies, configuration changes, migration procedures.
• Database Monitoring - Used Quest Spot Lite to monitor and diagnose different problems.
• Used ERWIN to carry out Logical and Physical data modeling
• Configured Business Intelligence and Data Warehousing with SSAS
• Performed Cube Development with SSAS
• Used SSIS to Load Data Warehouses
• Wrote MDX Queries
• Performed Data Mining with Analysis Services
• Configured Analysis Services Security
• Configuring and managing Virtual disks, Disk Mirrors and RAID 0, 1, 5 and 10 levels.
• Skilled in Planning, Configuration, Administration, and Maintenance of UNIX Solaris and Redhat/CentOS Systems.
• Install, Administer and maintain various Sun and x86 Servers running Solaris 8/9/10,
• Red Hat Enterprise Linux 4/5 and SUSE Linux Enterprise Server 9/10.
• Extensive knowledge in UNIX Bash Shell Scripting using AWK and SED and Crontab.
• Monitor Performance on Solaris 8/9/10, Red Hat Enterprise Linux 4/5 and SUSE Linux Enterprise Server 9/10.
• Configured Zones and Zones File system for Resource Sharing in Solaris 10.
• Prepared Shell Scripts for Process Automation, File System, Hardware and Network Alerts.
• Creating and Managing User and Group Administration and Access Privilege Setting with SUDOERS on Solaris, Red Hat Enterprise Linux and SUSE Linux Enterprise Server.

Environment: MS SQL Server 2012, 2008R2, 2005, 2000, Windows 2000 Advanced Server, Windows Server 2003 Enterprise Edition and Windows Server 2008 Enterprise Edition, Raid 10 storage.

Confidential, Fairfax, VA

Lead SQL Database Administrator / Systems Engineer

Responsibilities:

• Installed and Configure SQL Server 2000, 2005, 2008 in test and production environment.
• Upgrade databases from SQL Server 2000 to 2005 and 2000, 2005 to 2008 in test and production environment.
• Migrated MS Access 2003 databases into SQL Server 2008.
• Closely worked with business analyst to collect requirements & make systems available ASAP
• Work experience and strong knowledge in disaster recovery drills
• Rebuild Servers (Restore & Recovered from tape/CD backup) from backup

  Configured Log Shipping from Production to Standby Server (Running as Reporting Server)

• Assisted SQL developers to optimize SQL queries and Stored Procedures.
• Grant internal/external developers to development servers.
• Created Backup strategy for production and development environment.
• Analyze current maintenance and configuration; evaluate and adjust as required.
• Create effective data models, advocate proper data access and database maintenance, and determine and document strategies to resolve business requirements using database structures.
• Effectively articulate database requirements to non-database teams.
• Review developer SQL queries and stored procedure for optimization and security purposes, Security Management.
• Assist SQL developers to optimize SQL queries and Stored Procedures
• Used DBCC to check physical and logical consistency of database
• Working experience with SQL Server Integration Services(SSIS), DTS, ETL
• BCP to import & export data from flat files
• MS Access to MS SQL Server databases, Excel.
• Export & Import data from Oracle Database, MySQL, and Access Database including flat files like text, excel.
• Working experience with SQL Server Reporting Services (SSRS). Work with Microsoft SQL Reports to prepare reports for users and project teams.
• Used DTS, SSIS, BCP to import data from different sources like Oracle, My SQL into SQL Server Databases.
• Used Backward & Forward Engineering for designed Logical & Physical Data Modeling using ERWin, Visio, and SQL Server Data Diagram.
• Involved in creating and modifying tables, Index (Cluster/Non-Cluster), Constraints (Unique/Check), Views, Stored Procedures, Triggers.

Environment: Windows Server 2003, MS SQL Server 2008 R 2/2008/2005/2000 , Erwin 7.1 & Microsoft Visio 2003.

Confidential, MacLean, VA

SQL Database Administrator / Systems Engineer

Responsibilities:

• Responsible for Installation, Configuration and Administration of SQL Server 2005 on Windows 2003 Servers & Installation of Service Packs & hot fixes.
• Worked with database design team and development team for database design and implementation, used Visio for database design and SQL 2005 for development.
• Documentation of process involved while upgrading SQL server 2000 to 2005.
• Prepared Documentation for Disaster Recovery plan and used Log-Shipping for synchronizing databases as part of High Availability.
• Enhanced query performance with modification in TSQL queries, removing unnecessary columns, eliminating redundant and inconsistent data, normalizing database, establishing necessary joins, creating useful clustered index and non-clustered indexes.
• Monitoring SQL Server logs to ensure whether the backup operations, batch commands, scripts have completed successfully.
• Performance tuning and testing stored procedures, indexes and triggers using Database Engine tuning advisor and SQL server profiler.
• Monitoring SQL server performance using profiler to find the performance and dead locks.
• Used copy Data Base option to copy relatively small databases between servers in online mode.
• Created Maintenance Plans for Regular Backups and Rebuilding of Indexes.
• Creating SSIS Packages by using advanced tools (i.e. pivot Transformation, Derived Columns, Condition Split, Aggregations) to perform Data Conversion, Consolidation, Cleansing, Scrubbing, loading and data transformation.
• Successfully migrated data between different heterogeneous sources such as flat file, Excel and SQL Server 2005 using SSIS.
• Developed, deployed and monitored SSIS Packages. Implemented Incremental Load and Data cleaning by creating Dynamic SSIS package.
• Documented different Stages of data transformation, procedures and scripts involved in the database.
• 24 X 7 On Call support periodically.

Environment: Database: MS SQL Server 2000/2005, Access, Excel, Tools: SSIS, SSAS, Third Party Tools: MS Excel.