| SQL DBA - Remote - Contract - Persistent Systems at Remote, Remote, USA |
| Email: [email protected] |
| Hello Greeting from E-IT Position: SQL DBA Location: Remote Contract Client: Persistent Systems Specific Duties, Activities, and Responsibilities: 1. Owning, tracking and resolving database related incidents and requests 2. Ensuring the Performance and Stability of the RDBMS platforms 3. Providing, reviewing and resolving service related alerts/reports for maintenance, capacity, performance, ETL status 4. Diagnose and resolve database performance issues. 5. Proactively monitor the system 6. Deploy database change scripts in multiple environments 7. Help evaluate new technologies for inclusion in the environment Position Requirements: Education or Equivalent: BS in Computer Science or Information Systems or Equivalent Work Experience Experience or Equivalent: 8-10+ years experience working on relational database platform with emphasis on VLDBs. On-call deployment and troubleshooting experience Experience with database design principles, including normalization and aggregation, for both on-line and data warehouse schemas to support the needs of application developers. Knowledge, Skills, and Abilities Requirements: List unique knowledge, skills, or problem-solving requirements. Database Performance and Tuning Hardware analysis (Disk I/O, Network I/O, Processors, Memory) Database Configuration Management Database Capacity Planning and Monitoring Troubleshooting Wait State Analysis Database Backups/Restores Technologies Implementing New Database servers in a Virtual Environment Database Design Skills including Normalization and Data Warehouse design Strong TSQL skills Strong analytical skills Structured Troubleshooting Skills SQL Query Performance Tuning experience Log Shipping, Mirroring and Always-on technologies Replication Experience with Foglight and other 3rd party Monitoring Tools Experience in the healthcare industry, a plus Analyze, solve, and correct database issues in real time. Provide suggestions for solutions. Refine and automate regular processes. Track issues and document changes. Assist developers with query tuning and schema refinement. Minimize database downtime. Implement high-speed transaction recovery techniques Provide 24x7 on call rotation support for critical production systems. Perform scheduled maintenance and support release deployment activities after hours Toolset: Microsoft SQL Server 2014 thru 2022 Microsoft SQL Server 2017 Reporting Services (SSRS) Knowledge and experience with Transact SQL (stored procedure, trigger and constraint development) Azure Database MS-Windows Snowflake Physical/Mental Requirements: Ability to communicate clearly both verbally and in writing. Ability to analyze complex application and business operational issues. Critical thinking and problem-solving skills. Ability to work well in a team. Good time-management skills. Thanks & Regards Logesh | E-IT Professionals Corp. 17199 N Laurel Park Dr. Ste 402, Livonia, MI 48152 Email | [email protected] Keywords: information technology microsoft Michigan SQL DBA - Remote - Contract - Persistent Systems [email protected] |
| [email protected] View all |
| Thu Aug 29 03:20:00 UTC 2024 |