SUMMARY:

• Over 20 years of IT experience. Highly accomplished database technology Administrator, Architect and Leader.
• Experience in SQL Server relational Database Management systems, database development, BI development, SSRS Reporting, ETL Processes using SSIS and data warehousing. Major expertise in SQL Server administration, architecture, development, Troubleshooting, Performance Tuning, Security, Monitoring, High Availability and Disaster Recovery.
• Hands on experience in SQL Server Reporting Services, Integration services.
• Working knowledge of SQL Server Analysis Services, Visual Studio Team Foundation Server administration, Web Deployment and Configuration etc.

TECHNICAL SKILLS:

PLATFORMS: WINDOWS 2000 - 2012 SERVERS, AWS, AZURE ETC.

LANGUAGES: VISUAL BASIC, VB.NET, ASP, ASP.NET, HTML, VISUAL FOXPRO, C/C++, T-SQL,ETC.

RDBMS / DBMS: SQL SERVER 6.5/7.0/2000/2005/2008 R 2/ 2012/2014/2016, ORACLE 7.0, 8I, MS,ACCESS 97, 2000 ETC.

TOOLS: & SOFTWARE: IDERA, RED GATE TOOL BELT, LITESPEED, SPOTLIGHT, FOGLIGHT, BPA, FTP

PROFESSIONAL EXPERIENCE:

Confidential, Frisco, TX

Sr. SQL Database Architect/Lead

• Responsible for establishing the technical vision for Data services and provided overall leadership to the talented SQL Server, MongoDB and Hadoop DBAs.
• This includes directing all database operations to meet company’s business requirements as well as the support and maintenance of existing legacy applications.
• Responsible for managing of data infrastructure across company’s multiple data environments hosted on-premises, AWS, Azure and 1and1 clouds.
• This includes transactional systems deployed in Microsoft SQL Server 2005/2008R 2/ 2012/2014/2016, the Enterprise Data Warehouse environment deployed in MongoDB, Hadoop and the analytical environments. Database environment included 350+ standalone and cluster SQL servers, 4+ MongoDB clusters and 5+ Hadoop clusters with a team of 15+ DBAs.
• Also responsible for design and implementation of processes used to populate the data warehouse from both internal and external data sources. Involved in multiple migration plans.
• Implemented data archiving strategies. Implemented HADR solutions using SQL Always ON in SQL server 2014/2016.
• Worked with business stakeholders, external companies and other IT teams.
• Responsible for the enterprise wide report management, delivery and infrastructure using SSRS.
• Successfully managed more than 5,000 SSRS reports and Report subscriptions.
• Deployed and configured enterprise-wide ETL solutions using SSIS packages.
• Provided support for the in-house developed applications.
• Involved in internal and external audits

Confidential, Frisco, TX

Sr. SQL Database Administrator/Developer

• Responsible for overall database administration and architecture of the company’s EFT environment. Supported operations and projects.
• Worked in high volume transactional ATM data processing environments.
• Architect and implement high availability and HA & DR solutions. Improved availability of the mission critical database systems.
• Responsible for standards, design of physical data storage, maintenance, access, and security administration.
• Optimizing database access and allocating/re-allocating database resources for optimal configuration, database performance, and system resource utilization.
• Responsible for the day to day database administrative tasks, such as: proactive monitoring, error checking, performance tuning, replication, Log Shipping, database mirroring, always ON, troubleshooting, backup and recovery etc.
• Experienced is performance monitoring using PerfMon, PAL tool and DMVs. Investigating, reviewing, applying and testing all patches and bug fixes in the database environments and providing consultation on patch management, custom interface design and operational implementation.
• Managing user security to the databases to create a controlled access environment.
• Participated in planning, design, implementation, and testing of new and changing database configurations. Implemented Table partitioning in Production environment. Implemented sliding windows methodology for table partition maintenance.
• Working experience with multi TB (VLDBs) databases.
• Developed, Deployed and configured SSRS Reports and SSIS packages and provided enterprise wide solution.
• Used PowerShell scripting for customized solutions.
• Mentor DBAs, database developers, business analysts, testers etc.
• Develop queries, stored procedures, triggers, and scripts as needed.
• Worked with MS SQL server 2000/2005/ 2008 /2008 R 2/2012/2014. Used third party software such as Lite Speed for backups and Idera/Spotlight for monitoring.

Confidential, Lincoln, NE

Sr. Database Administrator/Architect

• Managed SQL database administration assignments for FACTS Management.
• Enhanced database availability, implemented backup/recovery procedures, handled performance tuning and implemented backup strategies.
• Ensured technical and functional designs to meet business requirements. Responsible for Database Installation, Configuration, Maintenance and availability, Database security, Server Security, SQL Encryption, Compression, Capacity planning, Performance monitoring, Database and query Performance tuning, Disaster recovery, setting up Replication, Log Shipping and database Mirroring.
• Worked with SQL Server 2005, 2008, 2008 R2.
• Developed, Deployed and configured SSRS Reports and SSIS packages using SQL server 2005 and SQL 208 R2.
• Installed and configured REDGATE software for database monitoring, schema comparison and database management.
• Along with the DBA duties, I was also responsible of change control management. Installed and configured Team Foundation Server 2005, 2008 & 2010. Managed multiple team projects in TFS.
• Used Customized process template for TFS server.
• Configuring websites, virtual directories, IIS, SSL etc. Responsible for .Net and SQL code deployment in various environments.

Confidential, Morgan Hill, CA

SQL Database Administrator / Developer

• Worked as a DBA / SQL developer. Implemented role base database security.
• Planned and implemented database maintenance plans. Scheduled Jobs. Configure alerts. Configured SQL Mail.
• Made changes and enhancements to the customized in-house development applications.
• Performed application and database consolidation.
• Developed stored procedures and Functions.
• Migrated from Visual FoxPro database into SQL server 2000.
• Installed and configured SQL Server 2005 and migrated legacy databases from SQL Server 2000 to SQL Server 2005.
• Define and implemented ETL processes.
• Created and maintained data warehouse. Used SQL OLAP to design cubes for business i.e. Sales, Expense, account payable, account receivable, Defect Analysis.

Confidential, Los Angeles, CA

Manager IT

• Responsible for the direct supervision of the technical teams i.e. Systems, Networking, DBA and developers to ensure deliverables are deployed in a timely manner and according to published team standards. Responsible for introducing and maintaining highly repeatable and reliable processes, as well as supporting standard and for establishing and leading highly performing, appropriately skilled technical teams. Managed complex system administration and/or development.
• Responsible for supervision and coordination of all technical staff within their area of responsibility.
• Participates in cross functional design and development efforts to ensure optimal end to end solutions. Defines and promotes standards for coding, testing, deployment to Production.
• Defines and ensures compliance of standards for building systems, configuring operating systems and ensures security compliance.

Confidential, Los Angeles, CA

SQL Server DBA / Developer

• Software Designing & Development. Provide Business Solutions. While Supporting Manufacturing needs, Analyze, Design and developed new Applications for current and future requirements. Programmed business rules. Data stored in SQL Server 2000.
• Normalized and Designed Database, create tables, indexes and views. Create database roles and users. Set security.
• Used DDL, DML and DCL. Used and planned Backup and Restore.
• Defined Jobs, Alerts and Operator.
• Used BCP and DTS for ETL processes. Setup snapshot Replication.
• Use Profiler for performance tuning.
• Wrote database stored procedure, triggers and create functions. Used transaction in stored procedure and triggers.
• Adopted ACID standard.
• Create OLAP Cubes i.e. Sales, Expense, Yarns, Dyes & Chemicals, RGA, QA. Work on Web Administration for Kronfli’s website.
• Used FTP pro.

Confidential, Los Angeles, CA

SQL DBA / Developer

• As a contractor, Worked on SQL Server 6.5. Maintained tables & indexes.
• Wrote Stored Procedure & Database Triggers.
• Customized Financial Reports using embedded SQL.
• Enhanced SQL queries. Gave a complete financial solution, which worked with SQL Platinum.
• Enhanced some Report in SQL Platinum. Windows NT 4.0 used for server.

Confidential, Canoga Park, CA

Programmer Analyst

• Developed and developed a financial accounting package, which fulfill financial requirements i.e. Cash Flow, Bank transactions, individual account heads, financial statements, account ledger of each account head. This software was developed in Visual FoxPro 5.0.