• SQL Server Consultant Jobs in Gandhinagar,India - 23844946

  • Infosense Pvt. Ltd
  • Save Job
  • 5 - 10 Years
  • Posted : above 1 month

Job Description:







  • This position is responsible to architecting, managing and administration MS SQL Server Instances and Databases, including development support of daily operations and helps to develop strategies to improve availability and utilization of SQL Server Environment of multination clients having database sizes in multi terabytes on on-prem and cloud

     

    Candidate must have played varying role of SQL Server Architecture, DBA and Developer and on-prim and cloud environment

     


  • Experience Range





  • 5 to 10 years as MS SQL Server Database Administrator cum Developer

  • Played roles of SQL Server Architecture, DBA and Developer and on-prim and cloud environment




  •  


  • High Availability and Disaster Recovery Solution


  • Well experienced in Architecting, Implementing, Administering and troubleshooting issues with High Availability and Disaster Recovery solution like Distributed AlwaysON Availability Groups, AlwaysON Availability Groups, AlwaysOn Clustering, Log Shipping, Replication and Mirroring solutions

  • Custom replication using CDC and Oracle GoldenGate





  •  


  • Installation, Configuration, Migration and Upgrades 


  • Installation and architecting instance and feature and option usage considering license requirement

  • Hardening OS and SQL Server Instance for best performance and compliance with best practices implementation

  • Successfully migrated / upgraded SQL server Database Instances from various lower releases to high releases

  • Migrated large databases with replication solution and CDC/GoldenGate from on-prem to Cloud Environment with zero downtime with respect to database side

  • Developed strategy and implementation plan for transitioning MS SQL Server on premise to AWS / Azure cloud





  •  


  • Administration


  • Have hand on experience in administering very large and complex databases of size in TBs and managing multiple database environment having multiple database servers

  • Administering physical and logical areas of SQL server instance

  • Space management with data files, log files, tempdb and database and database objects growth monitoring

  • Daily monitoring on performance, backups, and resource utilization with database server and applications





  •  


  • Performance Tuning


  • Worked extensively native performance tuning tools for Troubleshooting Performance issues like Database Experiment Assistance, PSSDiag, Tuning Adviser, Index Tuning Advisor, SQL Profiler and Extended events, Activity Monitor

  • Developed and used various DMVs and DBCC commands around performance issue troubleshooting

  • Various OS tools like PerfMon, Activity Monitor, Performance Monitor and Resource Monitor usage and analysis

  • Have practical experience in resolving issues with code and optimizing T-SQL / PL-SQL code with different ideas and suggestions for best performance and lowering down resource usage

  • Indexes Tuning Good understanding of index technology, defragmentation and overlapping and duplicate indexes

  • Statistics implementation of stat gathering solution and identifying duplicate states and issues with statistics

  • Well knows new features and changes with SQL server optimizer and releases like Query Store, Cardinality Execution etc

  • IN-Memory Optimization





  •  


  • Backup & Recovery


  • Implemented sound backup and recovery strategy considering PITR requirement and disaster

  • Implemented backup solution using maintenance plan and custom solution and enterprise backup management tools like – CommVault and Symantec NetBackup Exec





  •  


  • Features and Technology Usage


  • Data Compression, Indexing, Contained Database, Change Data Capture (For replication/data auditing)

  • Full Text Indexing,

  • Partitioning,

  • Indexed Views

  • Transact SQL (T-SQL) Coding, XML Queries, PL/SQL development experience with stored procedure, function, trigger and view and others

  • Always Encrypted utilization; Dynamic Data Masking utilization





  •  


  • Compliances and Security


  • Well worse in implementation security and auditing standard for various compliances like CIS, FFIEC, SOX, HIPPA depending on Line of Business of organization

  • Implemented user access and security procedures in accordance compliance requirement





  •  


  • Monitoring and Health Check


  • Developed tons of monitoring scripts, SQL Jobs and PowerShell Scripts and alerting system,

  • Hands on experience in monitoring solution implementation of 13c EM and SentryONE monitoring tools





  •  


  • PowerShell Scripting


  • Have knowledge of Powershell scripts for automation and routine tasks for simplifying administrative tasks (Leads towards less involvement of human hours)





  •  


  • Development Support / Product Development Life Cycle


  • Managing and administration of Development/QA/Staging/Production environment process like change management, build process for new development and product release and automation with deployment process

  • Automation for database refresh and schema refresh for development support from production to lower environment

  • Profile Summary:

    Employment Type : Full Time
    Eligibility : Any Graduate
    Industry : IT-Software
    Functional Area : IT Software : Software Products & Services
    Role : Database Administration (DBA)
    Salary : Rs 7.50 - 15.00 Lacs p.a.
    Deadline : 18th Apr 2020

    Key Skills:

    These are some of our most popular tutorials

    People who search this job also searched for the following Keywords

    Sourced**

    Salary trends based on over 1 crore profiles

    View Salaries

    All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status