Looking for someone who can develop payment solution application for my project.
-Experience with Oracle database management (RAC,12C, Dataguard)
-Experience with PostgreSQL databases
-Experience leading a team of database developers
-Good working knowledge on Windows server and Linux, e.g. Red Hat
-Experience of working within a PCI compliant environment
-SQL Server Reporting Services
-SQL Server Integration Services
-Understanding of SQL Server Analysis Services
-Has 8+ years of experience in support in MS SQL Server environments.
-Strong experience in Database Administration in SQL Server (2008 R2, 2012, 2016)
-Able to perform SQL server installation and configurations
-Experience in troubleshooting and resolving database integrity issues, performance issues, -blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc.
-Experience in Performance Tuning, Query Optimization, using Performance Monitor, DMV’s and other related monitoring and troubleshooting tools.
-Ability to detect and troubleshoot SQL Server related CPU, memory, I/O, disk space and other resource contention.
-Strong knowledge of backups, restores, recovery models, database shrink operations, DBCC commands
-Strong Knowledge of Clustering, Always-ON, Replication.
-Strong knowledge of how indexes, index management, integrity checks, configuration, patching. --How statistics work, how indexes are stored, how they can be created and managed effectively.
-Knowledge of SQL Server tools (DTA, SSMS, SAC, SSCM, PerfMon, DMVs, system sprocs)
-SQL Development – ability to write and troubleshoot SQL programs and design performance-optimal programs (stored procs, functions, tables, views, triggers, indexes, constraints)
-Expert experience in implementing operational automation
-Knowledge of T-SQL and PowerShell scripting
-Need to have good knowledge on storage systems like NAS, SAN
-Documentation skills for processes and procedures (runbooks, topology etc)