Prod Sql Dba
Wellington & Wairarapa, New Zealand
- SQL Server production database support & Troubleshooting All versions( 2000-> 2012)- SQL Server services Installation, applying Service packs- Installation & maintenance of SQL Clustering (A/A, A/P, Multi node)- Creating and maintaining Always On availability groups- Configuring Database Mirroring, async & synchronous with monitor- Setting up Log Shipping with custom backup & onsite/offsite/ftp restore- Setting up SQL Replication (transnational, merge, snapshot, P2P)- Administer large number of SQL Servers by using Policy-Based Management, designed & applied custom policies- Created custom DBA script using DMVs, system tables for database management- Using SQL Server dashboard reports, DMVs and Profiler to identify slow or hardware resource consuming T-SQL queries- Capacity planning for new systems, space management & growth planning for existing SQL Servers- Capacity Planning and benchmarking SQL Server hardware, CPU, Memory, cache, Disk IO, RAID, Network- Created Table & Index Partitioning schemes for scalability and easier data manageability - Evaluating and applying SQL Data compression - Row, Page level- Securing data using Encryption- TDE, cryptographic function, Key, Certificate- Database Security- Role, login, user and permissions Management- Setup custom Database maintenance plan, DBCC, maintain statistics, Integrity Check, trace flags - Identify unused indexes; create missing indexes and regular reorg/rebuild Index maintenance- Evaluating Database Locking Architect, Diagnosing and Resolving Deadlocks, blocking, Latch contention and timeouts- Developing SQL Scripts and stored procedures in creating new sql agent jobs and other database maintenance plans.-Generating reports by Powershell using SSRS for capacity planning and analysis management -Building proactive and centralized monitoring system for Database environments with power shell scripts and T-SQL Scripts-Creating SQL DBA best practices & enforcing guidelines across teams