We provide IT Staff Augmentation Services!

Database Administrator Resume Profile

SUMMARY of SKILLS

  • Seasoned Microsoft certified SQL Server Database Administrator with over 8 years of proven IT experience in SQL Server database administration, design and development network support and system administration.
  • Extensive experience with both production and development enterprise SQL server database administration, monitoring, performance tuning optimization, automating repetitive tasks, and analyzing database performance and allocating and configuring server resources to achieve optimum database performance.
  • Extensive Experience in installing, configuring, managing, monitoring and troubleshooting SQL Server.
  • Hands on experience with T-SQL in constructing administrative scripts and writing/tuning triggers, tables, user functions, views, indexes.
  • Experience with all aspects of database analysis, data modeling, database administration, data warehousing/BI and data mining
  • Familiar in developing SSIS Packages
  • Solid experience architecting different SQL Server high availability solutions, including Log Shipping, mirroring, failover clustering FCI and the AlwaysOn Availability Groups in SQL Server 2012 and 2014.
  • Outstanding ability to analyze, develop, and implement technology solutions.
  • Have experience using industry standard monitoring tools like Idera Diagnostic Manager, SQL Sentry and most of RedGate utilities
  • Appreciates challenges, steep learning curves, and high-pressure deadlines. Reliable team player with effective troubleshooting and debugging experience. Equally strong project leadership experience, introduces out-of-the box thinking and problem-solving analysis that improve processes, systems, and methodologies currently in place and exceed business goals and customer expectations.

PROFESSIONAL EXPERIENCE

Database Administrator

Confidential

  • Performed all aspects of database administration and applied best practices for performance, security and manageability.
  • Optimized SharePoint SQL Server infrastructure which resulted in tremendous improvement in user experience
  • Migrated most of our SQL Server infrastructure from standalone 2008 R2 instances on Windows 2008R2 to clustered SQL Server 2012 and 2014 instances on Windows 2008R2 and Windows 2012R2 .
  • Designed and architected SQL Server infrastructure to migrate Oracle based CRM and Finance applications to SQL Server based applications Blackbaud CRM and Unit 4/Agresso Business World . This includes but not limited to seizing and testing storage system, backup and recovery strategy, High Availability and Disaster Recovery Strategy, automating set up and installation and helping on ETL and migration/conversion etc
  • Automated SQL Server installation that cuts down time it took to spin up a new box.
  • Deployed/Maintained Master Data Services MDS , work with Microsoft support resolving MDS related bugs
  • Evaluated and deployed 3rd party monitoring tool along with in house monitoring solutions.
  • Created baseline and inventory of all SQL Server systems

Database Administrator

Confidential

  • Performed all aspects of database administration
  • Maintained SQL Server Databases using custom scripts and third party monitoring tools automated numerous functions.
  • Performed performance tuning, archiving, backup, recovery, software upgrades, capacity planning and optimization for SQL Server database.
  • Optimization and tuning of database servers including indexing and storage
  • Automate routine and repetitive administrative tasks, wrote T-SQL Transact-SQL scripts, stored procedures, triggers
  • Designed and implemented backup policies and procedures, Security policy and procedures including auditing
  • Installed, configured and upgraded different SQL Server versions from SQL Server 2000/2005 to 2008R2 and now working on migration to 2012
  • Hardened installations for security and implemented least privilege security policy
  • Involved in deploying and tuning Data warehouse
  • Generate reports using Business Objects and Microsoft Reporting tools SSRS
  • Setup and Administer SAP Business Objects instances for Personify Application and other inhouse reporting needs

IT Operations Support

Confidential

  • Managed lab network, provided troubleshooting for users, and ensured efficiency of campus-wide computer operations.
  • Coordinate, manage, and track support activities using ticketing systems.
  • Did regular maintenance and troubleshooting of computers, printers and office equipments and networking

Database Administrator / Developer

Confidential

  • Maintained SQL Server Database ensured accuracy of information and automated numerous functions.
  • Performed all aspects of database analysis, data modeling and database administration, data warehousing/BI and data mining,
  • Involved in design and implementation of a database after gathering and analyzing database requirements
  • Performed database logical and physical design, maintenance, tuning, archiving, backup, replication, recovery, software upgrades, capacity planning and optimization for SQL Server database.
  • Automate routine and repetitive administrative tasks, wrote T-SQL Transact-SQL scripts, stored procedures, triggers
  • Generate reports using Crystal Reports and Microsoft Reporting tools SSRS .
  • Designed and implemented incremental and full backup policies and procedures
  • Created and implemented database design solutions in collaboration with programming team.
  • Ensured data integrity and performance of databases
  • Installed, configured and upgraded different SQL Server versions.
  • Loaded data in to the Data warehouse using SSIS, build cubes for analysis, made thorough analysis on the data and came up with reports using SSRS
  • Developed documentation that sufficiently describes technical deliverable as required for internal controls so that the maintenance responsibility can be passed on to production support team.

Database and Systems Administrator Sept

Confidential

  • Windows based System administration, maintenance, customer support, and network support.
  • Actively involved in different stages of Project Life Cycle.
  • Managed Users roles and permissions.
  • Configured database mail and created profiles and accounts for appropriate users.
  • Created backup plans through jobs and maintenance plan
  • Support various applications.

TECHNICAL SKILLS

RDBMS: MS SQL Server

  • Database Technology/Tools: SSMS, SSIS, SSAS, SSRS, BI Tools, DTS, ETL, Data Mining, Profiler, Database Engine Tuning Advisor, Replication, Mirroring, Clustering, AlwaysON, DBCC commands, MS Visio, Business Objects Administration, Idera Diagnostic Manager
  • Programming Languages: T-SQL, PowerShell, Python, ASP.net, C/ C /VB, HTML
  • Operating Systems: All Windows versions both client and Server and familiarity with iOS, Linux
  • Hardware: Troubleshooting and maintenance of Computers, Servers, Printers and other office machines

Hire Now