SQL Server Developer DBA
Project North Database Migration: This Project North (PN) project involves the sale of [company name] landline accounts to Frontier/Spinco and my roles and responsibilities to migrate COFEE Billing East & West , AMT, VDO, BOSS, Survey, Arbor to a separate database including Installation, Configuration, Backup & Recovery, Database Security, Data Transformation Services, Database designing.Net backups configuration.
- Perform day to day Database Maintenance tasks -- Clustered & Non-clustered Database Monitoring, Backups, Space Management, Resource Utilization, responsible for performing object migration between all production database Servers
- Manage hierarchical security (access control, permissions, encryption keys and certificates) for databases and ensure data integrity using templates and schemas per, Sarbanes-Oxley Act. Ability to prepare for and participate in security audits and database encryption, and disaster recovery measures.
- Troubleshoot database performance issues and tune database objects. Set up traces and Profiler to troubleshoot performance issues. Analyze deadlocks & diagnose issues on the server.