IT-Systemanalytiker/in

Performing scalability, high availability, migration, and consolidation consulting on the Microsoft SQL Server platform as a Senior Database Consultant.
Designing high availability solutions with disaster recovery on separate geographical locations for various clients, including federal government departments and private corporates.
Design and implement robust database administration solutions including resource management, security, backup and recovery, performance monitoring and tuning, data management and capacity planning, planning, and implementing failover between database instances.
Design and implement scripts for instance monitoring, maintenance, backup, cloning, etc. Muneeb: +97152848313utilizing T-SQL, SSIS, Reporting Services and Analysis Services.
Apply data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations
Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end.
Refine and automate regular processes, track issues, and document changes.
Assist developers with complex query tuning and schema refinement.
Provide 24x7 support for critical production systems.
Perform scheduled maintenance and support release deployment activities after hours.
Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members.
Delivering training sessions to different teams in the company and client people national and international.
Installation, configuration, upgrading and administration/maintenance of Microsoft SQL Server and related products. Additionally setting up test, development, staging and production environment.
Managing user service accounts, proxy accounts, mail operators, users, roles management using various security matrix.

•Deployment and administration of Oracle DBMS 10g, Application Server 10g on server machines
•Installation and configuration of Toad for Oracle, Oracle SQL Developer
•Creation and maintenance of all databases required for testing, training & production usage using Oracle Database 8 / 8i / 10g.
•Performed database up gradation of Oracle 8i to 10g versions.
•Creation of different schemas for test, training, and production purpose databases and managing connection identifiers.
•Creation of database users, roles, indexes, synonyms, materialized views, sequences etc objects for test, training and production databases.
•Execution of application update patches, scripts forwarded by the central office, back-end stored procedures, triggers, and rules.
•Validating procedures, packages, functions etc. after the database updating process.
•Storage management for test, training and production purpose database objects, tablespaces, relocation of data files, management of back-end stored procedures, triggers, rules, tables, views, privileges, roles, auditing, and indexes.
•Installation of Oracle/SQL Server 2008 R2 cluster and configure Oracle data guard and mirroring as DR solution.
•Performs periodical tuning of Oracle database instances according to the database load
•Monitoring workload of resources during data production and managing user sessions for production databases.
•Ensuring daily, weekly, monthly backups using cold & hot backup techniques, RMAN, Import/Export backup utilities.
•Implements and manages unauthorized access to the Oracle databases & production schemas.
•Puts standards in place to ensure that all application design and code is produced with proper integrity, security, and performance.
•Convert required data from different databases by making scripts and using Import / Export, SQL Loader.
•Preparation of reports by comparing and analysis of data provided by different govt. departments on the basis of unique identifiers.

Anderes Zertifikat

Anderes Zertifikat