US-Data Engineer-5

Description: MS SQL Server Database Administrator Shift - Must work US eastern business hours Max Bill Rate: XXXX/hr minus fees LOCATION IS RICHARDSON, TX • Participates in or leads a Data Engineering Team supporting one or more application projects. • Works collaboratively with the Application team, including architects, developers and testers, to ensure project success. • Engages and collaborates with the infrastructure DBA teams to ensure delivery of DB infrastructure components. Ensure integration of DE deliverables with other project deliverables. • Collaborates with the Application Project manager to plan and manage the DE activities and deliverables. • Coaches less experienced DE team members. • Participates in discussion with customers and peers to collect and analyze data requirements. • Contributes significant, new and innovative ideas to the DE knowledge base. • Active participant in one or more DE communities. Regularly contributes to discussions, forums and knowledge base. • Provides input and advice to peers, management and customers in relation to data engineering principles, technologies, methods and best practices, within areas of expertise. • Participates in solution development for small/medium deals. Participates in client meetings and presentations. • Assists Data Architect or DE Leader develop solutions by documenting components of the solution, defining deliverables and preparing estimates. • DBA: • Plans and Leads database development and maintenance of databases including: • design database environments and databases • design, develop, modify, test, release/deploy and maintain database objects • design database objects and supervise develop, modify, test, release/deploy and • maintain by other DBAs • design, develop, modify, test, release/deploy and maintain database security and audit • solutions • design, develop, modify, test, release/deploy and maintain database recovery solutions • execute database and data recovery • manage database performance, capacity and availability • DBMS SW implementation, upgrade, patching • Utilizing best practices, work plans, checklists and defined processes. • Proactively supports application teams. Performs SQL tuning. • Provides advice on application data issues. • Participates in project technical reviews. Leads work product reviews. • Develops and maintains database support documentation. • Designs database monitoring solutions and assists others in monitoring and proactively anticipating or identifying issues. • Takes ownership of complex database incidents and problems and provides resolutions in a timely manner. • Engages SMEs or vendors to provide assistance to resolve more complex incidents as required. • Job Responsibilities • Participate in production SQL database 24x7 on call support. • Build/Upgrade and tune SQL databases. • Backup and Restore databases as appropriate. • Tune and resolve database performance problems. • Effectively manage and monitor all aspects of RDBMS environment. • Support development, test, and production SQL databases. • Develop/maintain SQL packages, procedures, and functions. • Implement new database change requests. • Assist developers with SQL issues and questions. • Follow and contribute to database best practices. • Qualifications DATABASE skills: • SSAS, SSIS, SSRS and cubes expertise preferred • Able to use utilities to backup, reorg, recover, unload, load tables. Create, change and modify DB structures. • Perform space monitoring and performance and tuning. • Production Support on-call rotation, off shift and weekend work possible. • Adhere to all defined standards and processes and documentation. • Platform: MS Windows, knowledge in SQL Server tools. • SQL programming a plus. • Need to be able to effectively communicate orally and written with users, team members, management, and supervisors. • Must possess strong leadership and problem solving skills and have the ability to multitask and thrive in a flexible and demanding environment Education and Experience Required: • Job experience as a DBA supporting SQL databases. • Knowledge and Skills: At least 8 years with production support, performance monitoring • and tuning, problem identification and solution, modifying database structures, backup, • recovery, disaster recovery tests. • MS Windows • SQL 2017