SQL Server DBA

 Job Description :-
       Provide support for a large SQL Server Database environment.
       Administration of databases, including set-up, backup processes, documentation updates, monitoring and maintenance. Understand and expand the architecture of the Microsoft solution.\
       Resolve and provide solution to technical issues arising in the production environment.
       Design and implementation of database replication strategies for both internal and DR requirements procedures. Determine, implement, and manage database backup and recovery strategies, with focus on PIT recovery.
       Extensive experience writing SQL and stored procedures and query tuning on high transaction systems.
       Experienced in SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS).
       Sound knowledge of RDBMS concepts, database architecture and SQL/SQL .
       Proficient with SQL server profiler for monitoring and troubleshooting database activity and performance.
       Extensive experience in SQL Server Clustering and HA technologies including mirroring, log shipping, failover cluster and various replication technologies would be an advantage.
       Knowledge of other databases like SQL, No SQL databases and In-memory databases.
       Support the design and implementation of added functionality. Assist with Disaster Recovery considerations for the DBA team.
       Sound knowledge in Security standards and Microsoft recommendations.
       Performance tuning & database optimization.

1.         Server (troubleshooting, debugging, tuning and optimization of SQL queries and stored procedures).

       Database administration (Replication, design experience with RDBMS.
       DR: doing quality assurance of the database components released to production.
       Ongoing database performance tuning and upgrades, including: monitoring and evaluation of all database patches and service packs.