SQLDeveloper or DBA || Columbus, Ohio-2 days onsite, 3 days remote Must be living in Ohio. at Columbus, Ohio, USA |
Email: [email protected] |
From: Garima, TEK Inspirations LLC [email protected] Reply to: [email protected] Must be local to Ohio- Dont represent the location please!! SQL Developer/DBA Location- Columbus, Ohio- 2 days onsite, 3 days remote Must be living in Ohio. 3- 6 months contract to hire GC and USC Salary- 100k Conversion after 3-6 months Must have- SSIS/ETL package writing 60% 40% DBA SQL TSQL Script Writing Our Columbus Ohio client has a contract to hire opportunities for a SQL Developer who will report to the Director, Applications. REQUIRED QUALIFICATIONS: 5+ years of MS SQL Server 2012,2014,2016 developement/Administration 5+ years of SQL Profiler, Perfmon, and Query Plans 5+ years of TSQL script writing. Stored Procedures, Functions, Triggers 5+ years of Windows Server 2012,2016 5+ years of SSIS ETL Package writing 5+ years Database Configuration and Release Management 5+ years of Data Modeling and Normalization. DESIRED QUALIFICATIONS (NICE TO HAVE): NoSQL database experience (i.e. MongoDB, RavenDB, etc) Apache Solr Powershell Script Writing Strong interpersonal skills, able to communicate across a broad spectrum of users Excellent oral, written and presentation communication skills Development in an Agile environment Knowledge of AWS/Azure database services OLAP/Big Data knowledge a plus. POSITION OVERVIEW: The primary focus of this role is to ensure database stability and resiliency while also planning for growth and scaling as client grows. The position will perform basic DBA tasks such as backup plans, maintenance jobs, performance testing, monitoring, and reporting in a MSSQL environment. The position will also require an in depth knowledge of T-SQL, script writing, and server administration. Successful candidates will be self-starters and have a passion for infrastructure development. The role will be required to interface with 3rd party vendors and help to manage the IT budget spend. Collaboration with all client departments and with our enterprise customers is required, making good communication and interpersonal skills essential. KEY ACCOUNTABILITIES: Responsible for basic day-to-day SQL Server administration to all client application DBs Keeps SQL Server databases patched and on latest appropriate/feasible versions Performs server and system health checks on a daily basis. Troubleshoot problematic database issues and performance problems Orchestrates performance testing and strategies Works with vendors to arrive at cost-effective licensing and architecture strategies Works with development team to build and deploy their software releases Maintains and enhances system security framework to adhere with industry/client best practices Plan and implement upgrades needed to maintain service levels. Maintains existing and develops new reporting stored procedures as requested by the business. Has a deep understanding of TSQL in this area Has a deep understanding of disaster recovery/business continuity practices Advanced knowledge of backup and redundancy concepts. Log shipping, mirroring, etc. Interfaces with key business stakeholders to arrive at new requirements for the system from a data standpoint Deep understanding of schema design and data modeling. Has the ability to look at a vendor system schema and be able to write reports Assist in managing client Tech Support queue Embraces the client culture, supports the client Credo, and demonstrates commitment to the client mission and passion for the environment. Achieves targeted goals and business results through creativity, initiative, and personal accountability, while realizing true work-life balance. Comfortable working on multiple high priority tasks and interacting with business unit leads to resolve issues. Keywords: information technology green card microsoft |
[email protected] View all |
Fri Oct 27 20:53:00 UTC 2023 |