Us Citizen
Green Card
EAD (OPT/CPT/GC/H4)
H1B Work Permit
Corp-Corp
Consulting/Contract
UG :- - Not Required
PG :- - Not Required
No of position :- ( 1 )
Post :- 12th Nov 2020
Title : SQL DBA
Location : Charlotte, NC
Create and modify database structures based on DDL generated from methodology tool or database package• Application development: design, code, optimize databases for internal Sunbelt applications - this includes table structure design and stored procedures, as well as security aspects, to be used by the software engineering team• Maintain documentation describing the database systems infrastructure and major processes• Task scheduling, coordinate backups, batch processing, and maintenance schedules with network administrators to ensure optimal performance and system uptime• Assist developers as needed with guidance in efficient query design• Tune and monitor databases for efficiency – periodically reorganizing databases for optimal performance during scheduled down time• Create indices and manipulate tuning parameters where needed to enhance performance; identify processing bottlenecks and inefficiencies in query & process design• Capacity Planning: calculate volumetric equations to estimate new database sizes and plan appropriately for growth and communicate plans to server administrators• Participate in application development processes to facilitate good database design and access techniques• Support application teams and resolve database problems• Ensure a consistent and high level of service is delivered to end users in accordance with the departmental Service Level Agreement (SLA)• Coordinates with server administrators regarding software installation, upgrades and fixes• Participate in determining and testing backup and recovery procedures for production databases• Participate in the development, implementation, and maintenance of policies, objectives, short- and long-range planning of data systems• Maintain a broad knowledge of state-of-the-art technology, equipment, and systems Requirements:Education & Experience:• Bachelors degree in computer science or other relevant engineering field or equivalent work experience• 7+ years of experience in IT database administration and architecture• Demonstrated practical knowledge of database design, programming, installation and configuration, optimization, and troubleshooting• Experience with SQL Server 2014 and above, T-SQL, Integration Services (SSIS)• Familiarity with SQL Reporting Services (SSRS)• Familiarity with SQL Analysis Services (SSAS) a plus• Familiarity with C#, ASP.net, and the .Net Framework• Familiarity with Microsoft Azure a plus• Ability to interpret, adapt, communicate, and apply guidelines and procedures• Ability to develop and implement short- and long-range computer systems, capacity, and operational plans• Knowledge of business practices and procedures
Thanks & Regards
Indrajeet Mishra
IDC Technologies Sol.(I) Pvt. Ltd.
Email ID: indrajeet.m@idctechnologies.com
Website: www.idctechnologies.com