Senior Developer |SSIS |amp| SQL DBA|

We are seeking a highly skilled Senior Developer with expertise in SSIS and SQL DBA to join our team. The ideal candidate should have a Bachelor's degree and 5+ years of experience in SSIS and SQL DBA. Proficiency in T-SQL, SSIS, and data warehousing concepts is required. The Sr. Developer will be responsible for designing, developing, and maintaining ETL processes using SSIS and managing SQL databases. Strong problem-solving skills and excellent communication skills are necessary for success in this role. If you are a self-motivated, detail-oriented Sr. Developer with a passion for technology and innovation, we encourage you to apply.


About InterraIT:
We are a Silicon Valley-based IT services organization with nearly 30 years of industry experience. We are accredited at SEI-CMM Level 5 and ISO +001:2015 certified, offering cutting-edge business and technology solutions, as well as immersive digital experiences to clients worldwide. Our clientele includes Fortune 500 companies, and we provide end-to-end solutions to help clients achieve their ROI-based business goals and stay competitive. We are proud to have been recognized as one of India's Top 20 Best Employers by the IDC-DQ Best Employers Survey, as well as receiving awards for Workplace Excellence from Economics Times and Digital Transformation Enabler from Entrepreneur.com

Required Skills:
SQL DBA Skillsets
Server setup
Database activities
Job creation
SSIS Deployment
ETL
SSAS
SQL Security
Microsoft Power Platform Skillsets
Experience in Microsoft Platform and Office 365
Gateway creation
Power BI (Reporting)
Power Platform Admin Centre (DLP/Code promotion/CICD etc.)
Job Requirements:
DB System Administration
Responsible for performing all functions required to support day-to-day database operations
Provide 24x7 support for production systems
Perform database troubleshooting, re-organizations, re-indexing, copying, creating, tune databases, tables and queries as required to assist performance and ensure maximum uptime of the database
Provide strategic database direction
Support Microsoft Visio/Project
Availability in response to the needs of our customers for installation, maintenance and malfunctions
Determine and analyse requirements, perform design review, remediation and
recommendations
Participate in change control activities and project initiatives
Provide essential and adequate controls to secure and safeguard the integrity of the data being processed
Protect data and networks from unauthorized access, alteration, and misuse
Report any violations of the policy to management
Ensure Systems Availability
Perform day-to-day support tasks such as working with the business and applications team
Design, develop, create, and modify databases, schematics and tables
Monitor systems to ensure stability and take proactive actions to ensure the performance and availability of SLAs
Implement self-diagnostics and remediation solutions
Prepare systems availability reports and document reasons for exceptions and corrective action to rectify problems
Provide root cause analysis (RCA) as needed
Prepare performance and capacity trend charts to allow for proper upgrade planning with adequate time allowance to ensure enough systems resources are available when needed
Support disaster recovery effort that adequately meets the business needs and avoids extended system outages should an event occurs.
Support of IT and Business Application projects
Responsible for estimating time to complete project task(s) in support of IT, Business and End User projects
Responsible for analyzing, designing, installing, configuring, maintaining, and repairing of data and application components
Manage assigned projects and program components to deliver services in accordance with established objectives
Respond to inquiries from staff, administrators, service providers, site personnel and outside vendors etc. to provide technical assistance and support
Effectively communicate, verbally and in writing, with IT applications, management, and users on projects and raise any issues and delays to IT management
Promote and work in a team environment
Support the implementation of new technologies and tools that provide an efficient and cost-effective infrastructure environment in support of our customer business objectives
Keep informed of new technologies using in-house web training and vendor-offered training classes and seminars
Provide technical leadership, analysis, expertise, guidance, and act as a consultant to Infrastructure and IT Business application groups. Read more