Experience

NSTAR Technologies

• United States
• Professional Training and Coaching
• 1 - 100 Employee

• SQL Server Database Administrator

  • Aug 2016 - Present

  • Manage the configuration and maintenance of SQL Server 2017 and Azure SQL Database in development, test, and production environment. • Deploy and restore databases including point in time recovery. • Perform writing, debugging, and tuning T-SQL and stored procedures for optimum system performance. • Initiate scheduled jobs to automate several database activities which include maintenance plans for backups, rebuilding indexes, monitoring database health, disk space, and backup verification. • Develop backup/restore strategies and Disaster Recovery Solutions. • Ensure clean up and manipulation of data to comply with the 7 years Fair Credit Reporting Act (FCRA) requirement governing background check providers. • Implement, design, and apply High Availability Solutions: Managing replication, log shipping, mirroring, and clustering. • Configure and maintain fail-over clustering using Windows Server and SQL Server 2017. Execute system data migration from different databases and platforms to SQL Server databases. Show less



Maximus

• Australia
• Advertising Services
• 1 - 100 Employee

• SQL Database Administrator

  • May 2015 - Jul 2016

  • Upgraded/Migrated SQL Server Instances/Databases from older version SQL Server 2008R2 to 2012. • Created user security and access and procedures for the database system administrator. • Installed and configured operating systems for Windows 7 and Windows Server 2012R2. • Applied SP (Service Packs)/Hotfixes on SQL Server 2008R2, 2012 Enterprise Edition. • Rebuilt and updated indexes at regular intervals and when necessary for better query performance. • Worked individually and as a team member to collaboratively design and model systems at a high level before construction. • Deployed SSIS packages to move data across servers, move logins, load data from different data sources. • Executed database/infrastructure physical design, database upgrades, and applying software patches to databases as per application/client requirement. • Monitored server activity, error logs, space usage, and solving problems as needed. • Automated and managed maintenance jobs that ensured the stability and performance of database servers. • Conducted database consistency checks, backups/restores, recovery models, performance tuning, and optimized recovery procedures. • Implemented and managed replication, mirroring, clustering, and log shipping (High Availability Solutions). Show less