Sr. Database Administrator
Wisemani
مجموع سنوات الخبرة :13 years, 5 أشهر
Responsible for production, development, test environments with SQL Server 2016.
Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.
Apply data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations.
Help developers to write optimize query and tune existing queries/procedures.
Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end.
Perform backup and recovery and schedule automated jobs.
Refine and automate regular processes, track issues, and document changes.
Assist developers with complex query tuning and schema refinement.
Manage user’s security control access permissions and privileges.
Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues.
Carry out capacity planning requirement analysis.
Work closely with IT project managers, Developers, ETL and BI Programmers.
Responsible for production database with SQL Server 2012
▪ Managing and configuring SQL Server AlwaysOn Availability.
▪ Writing complex queries for manual reports and pulling on demand data.
▪ Writing complex queries for export data.
▪ Monitoring real time database performance and health.
▪ Monitoring storage and removing and shrinking unnecessary data..
▪ Working with end users and cooperate executive to identify business process and application requirements.
▪ Available for on call support and response to any emergency.
▪ Responsible for managing and configuring active directory.
▪ Managing security and administering user and permission for os and database.
▪ Managing and maintaining AD Services.
▪ Managing and Maintaining User security and permission both AD and Databasaes.
▪ Monitoring Storage.
▪ Responsible for production database with SQL Server 2005, 2008R2
▪ Configuring and managing SQL Server Cluster.
▪ Implementing and administering SQL Server Mirroring.
▪ Configuring and managing SQL Log Shipping.
▪ Responsible for oracle, SQL Server real time database performance monitoring, database troubleshooting & tuning, database emergency response / DR, and performed on call and support responsibilities.
▪ Write backup application backups, automatically delete old backups in accordance with our retention policies and record backup information in oracle, sql server database.
▪ Design and implement high availability solutions for a diverse group of clients.
▪ checking database health monitoring and deleting unnecessary log files.
▪ Db health monitoring through scripts as well as OEM, Export/Import (data pump) and customize profile scripts tune SQL and database engine.
▪ Working with end users and cooperate executive to identify business process and application requirements that can be a part of ERD.
▪ Conduct DCL, DDL code for testing databases and production databases.
▪ Implementing policies for auto script through different ways.
▪ Responsible for emergency response and performed on call and support rotation responsibilities and generating patch if required.
Installation of SQL Server Software and Related Products.
Establish and Maintain Backups on Local and Remote Media.
Performance Monitoring and tuning Using Performance Monitor, DBCC Commands, Maintenance Plans, Third Party Tools.
Analyze Applications Performance Using Query-Execution Plans, Index Utilization And Procedure Cache Utilization.
In Database Programming, Use of Indexes, Normalization Techniques, Execution Plans, T-SQL and Stored Procedures.
Plan Growth and Changes (Capacity Planning) with Team.
Database design development.
Tune Database Queries.
Optimization of SQL Server, Stored Procedures and SQL Scripts.
Monitor Application Related Jobs and Data Replication Activities.
Computer Science