| Sr. SQL Administrator || Bradenton, FL at Bradenton, Florida, USA |
| Email: [email protected] |
| From: Naveen, Smart IT Frame [email protected] Reply to: [email protected] Hi, Greetings from Smart IT Frame, Hope you are doing well!!! Smart IT Frame specializes in enabling you with your most critical line of resources. Whether its for permanent staffing, contract staffing, contract-to-hire or executive search, we understand the importance of delivering the most suitable talent; on time and within budget. With our Core focus in emerging technologies, we have provided global technology workforce solutions in North America, Canada & India. We take pride in delivering specialized talent, superior performance, and seamless execution to meet the challenging business needs of customers worldwide. Role: Sr. SQL Administrator Location: Day 1 Onsite in Bradenton, FL Type: Contract Shift: Day 9AM TO 6PM Job summary: SQL Server DB Administration Required Skills: SQL Server DB Administration Roles & Responsibilities Install and configure new Microsoft SQL Server instances, including availability groups and failover clustering. Review, analyze, and evaluate business systems and user needs by facilitating brainstorming Highly skilled at database design, installations, conversions Responsible for database backup and recovery procedures, access security and database integrity, physical data storage design and data storage management Participates in Database Management System selection and maintains database performance Engage in ongoing process improvement Experienced in Database Performance, Maintenance and Development to perform the following: o Database management including backups, recovery and maintenance o Database management for export, import and mass data loads o Analyzes and generation of all tables and index statistics o Monitoring and resolving data lock issues o Check all statistics related to memory, locks, I/O, database response time, wait events, top sessions and background processes o On-Line Transaction Processing (OLTP) to capture, validate and store large amounts of transactions o Create indexes to achieve critical dataset response time for time sensitive reports. Install SQL Server service packs and updates. Configure and manage SQL Security settings. Make system design recommendations according to Microsoft SQL Server best practices. Manage database backup & recovery & DR planning in collaboration with IT manager and System Engineer. Create, modify, and optimize SQL Server Agent jobs and maintenance plans. Proactively monitor SQL Server maintenance tasks, troubleshoot failed jobs and resolve issues in a timely manner Troubleshoot application slowness and performance issues. Responsible for T-SQL query tuning Responsible for database migrations and server upgrades. Develop documentation and training of routine database administration tasks and train server operations staff on these tasks. Perform SQL Server integration with enterprise applications. T-SQL Programming Perform additional tasks as assigned Qualifications: Experienced in Database Design and Development to perform the following: o New projects database design utilizing o Various objects development such as Packages, Procedures, Functions, Triggers for business logic implementation o PL/SQL procedures development, compilation and debugging SQL Server 2016 T-SQL, Stored Procedures o SQL Server Management Studio o DB Troubleshooting, performance and tuning Experience in Logical and Physical Database modelling -- Thanks & Regards Navaneetha Krishnan Senior Technical Recruiter Smart IT Frame LLC [email protected] https://www.linkedin.com/in/naveen-krishna-840a1619b/ www.smartitframe.com Keywords: database information technology procedural language Florida |
| [email protected] View all |
| Fri Jan 12 19:09:00 UTC 2024 |