| Job opening for SQL Developer Remote CA Must be local at Remote, Remote, USA |
| Email: [email protected] |
| From: Sushmita Soni, Sonitalent [email protected] Reply to: [email protected] Hi Hope you are doing well , We are looking for SQL Developer , please let me know if you are looking for this role and send me your updated resume also Job Title SQL Developer Job Location Remote -12302 Kerran St, Poway, CA 92064 Try to be local or nearby Duration 3 month contract if remote out of state if local then it can be more than 3 months Mode Of Interview - Phone/Skype Note -Need LinkedIn Job Description- CLIENT OVERVIEW: Corovan offers the industry's most comprehensive suite of commercial moving, storage, logistics, furniture, and tech services for businesses of all sizes and industries. Founded in 1948, Corovan is now the largest commercial moving and storage company in the Western U.S. We are proud to have the most experienced and dedicated team to support your workplace changes while ensuring safety, time and cost efficiency. The foundation of Corovan's success is built on win/win relationships with employees and customers, as well as on a progressive management team that's dedicated to continuous training and development. Fortune 500 companies look to Corovan for integrated workplace solutions, from internal shuffles and asset management, to corporate relocation and high-value equipment handling. Come experience the difference and let's get moving! ABOUT THE ROLE: Reason for this need: Corovan is in the middle of an ERP deployment and they would like to get some additional immediate help for one of their team members who is a database developer. Is well versed in SQL select statements using joins and where clauses Can export results of SQL queries to spreadsheet or delimited file Is comfortable creating new tables and populating them from files Is familiar with the use of mapping/lookup tables Can read and troubleshoot SQL stored procedures Can write stored procedures to transform data using mapping/lookup tables. Can configure notifications in SQL Server and trigger them based on errors or other stored procedure results. Has used data cleansing techniques to filter or correct bad data and remove redundant data Work in Excel to manage and update data, including the use of Infors Excel reporting add-in Additional nice-to-haves but not required: o Some level of familiarity with Visual Studio, C# development, VB troubleshooting, Entity Framework and inline application SQL. RESTful web services. ASP.NET web applications. IIS web hosting. SSRS. Intake call notes with Hiring Manager Intake with Kevin: ERP deployment trying to go live Nov 1st Exclusivity: not this time. He is talking to ERP deployment partner for resources and others in his network, needs to get help for this project ASAP Current person: struggling personally and professionally right now; Kevins SQL database developer is struggling with understanding the data they are working with and moving around and what it moves to the business. This contractor coming in needs to be a data person AND a database person 5-8 years of experience - someone that can come in and hit the ground running, Kevin doesnt care as much about years of experience In a perfect world, this candidates sits in SD, but Kevin cares more about hiring someone quickly Corovan has offices in Poway, San Jose, Oakland, Fullerton (FYI) SQL Server versions 2008 2019 any version of experience is fine Help migrate data to production systems ETL process needs to be finished and refined and performed Integrating systems together between the systems; SQL store procedures needs to be finished Ability to work on the programming side with .NET, not required, but highly preferred ETL processes Data mapping Optimizing queries Working on data- trying to take data from one system to another, what it means to the business, not just the transactional level Help augment processes and bring it to completion Interview process: Kevins developer will conduct interviews - Kevin may or may not join. If not, there may be a quick 2nd round. Standard work hours, will work closely with the Database Developer on the team Soft skills: Communication skills written and verbal, team player, dealing with financial data so they need to be trustworthy and credible Job Description: At Corovan, we continue to grow on the momentum of a great reputation. Corovan has a proven track record for excellence and continually exceeding industry standards. Corovan is a privately held company with a management team that genuinely cares about their employees. Our values include growth, customer service, continual improvement, and employee development. As a company, we work with interesting work environments with some of the most dynamic companies in the world. The Senior Database/BI Developer position is responsible for helping transition Corovan to 3rd party ERP data models and maintaining business-critical data processing and business intelligence operations on an ongoing basis. The Senior Database Developer will work as a developer while also providing technical leadership in master data management and BI development. Information Technology (IT) is responsible for the full lifecycle of infrastructure and technology solutions supporting Corovan. IT is required to support end-user functions, desktop and laptop platforms, voice, mobility as well as custom software solutions, server and network infrastructure. The IT departments commitment is to maintain a robust, highly available and cost-effective platform that allows the business to be agile in response to market opportunities. ESSENTIAL DUTIES AND RESPONSIBILITIES: Business Intelligence Development: Provide technical expertise using BI tools to help define, architect and build BI processes benefiting the entire organization. Create informative, actionable and accurate reporting that highlights relevant business trends and opportunities for improvement. Design and implement ongoing ETL processes supporting BI needs. Promote improved data visibility with business intelligence solutions, and act as a thought leader in maturing Corovans approach to BI. Strategic Planning and Analysis: Help plan and implement the cleaning and migration of critical data between data models using ETL best practices. Gather and document requirements for extensions to ERP data models based on business needs. Act as a primary owner of the master data management architecture for the organization. Study system capabilities, construct data model visualizations, and write specifications. Collaborate with the IT Director and application business owners to support existing applications and to design and implement new solutions to meet changing business needs. Determine operational objectives by studying business functions; gathering information; evaluating output requirements and formats. Participate in designing database backup and data-refresh procedures for on premise systems. Database Development: Design and develop Microsoft SQL stored procedures, T-SQL, views, ETL solutions, as well as reports via SSRS and SSIS. Maintain legacy data access code in stored procedures and other database objects as well as .Net web applications. Maintain and document existing custom and third-party integrated solutions. Collaborate and recommend design modifications and improvements with other software developers throughout the development process. Gather and document business requirements and project scope, user stories, detail functional specifications and effectively communicate project deliverables. Investigate gaps and inconsistencies in application and report data to determine root causes and propose remediation options. Design, implement and document stopgap procedures needed for routine data cleaning or to maintain data integrity. Review and approve other developers scripts for making changes to database objects. Assist with the improvement of our Agile SDLC, Scrum, and other processes. Create and execute test plans and test cases to support the quality assurance process. Maintain an understanding of the latest application and programming practices through education, study, and participation in conferences, workshops, and groups. Confer with team to resolve conflicts, prioritize needs, develop content criteria, choose solutions, and share knowledge. Customer Relations: Ability to have strong effective partnerships with senior leaders and functional leads to understand their business requirements and translate into project plans and create successful outcome. Able to have discussions with senior leaders about project timelines, project priorities, trade-offs relating to project schedules and lead discussions to effective resolution of these important items. Participate in meetings to coordinate service requirements, installations, and project milestones as required to achieve client expectations. Respond to incoming help desk tickets, emails and phone calls. Ensure help desk tickets are created for all user support requests. Resolve help desk tickets. Log time worked for all help desk tickets and IT projects. Participate in weekly on-call rotation for after-hours emergencies. Ability to work effectively in a team environment as a positive team player. Perform work with quality, efficiency and safety at all times. QUALIFICATIONS: To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. COMPETENCIES: 1. COMMUNICATION AND LEADERSHIP - Strong interpersonal and communication skills that allow this employee to effectively communicate with team members business partners. This person should be able to lead discussions to understand project direction, customer requirements, discuss trade-offs and solution approaches, and have discussions agreeing the priority of the projects in the portfolio. This person should also be able to communicate with external vendors and manage vendor relationships. Solid ability in both written and verbal communication. Effectively communicate with potentially stressful and/or emotional situations. Outstanding customer oriented skills. 2. PROBLEM SOLVING AND DECISION MAKING SKILLS Strong troubleshooting/problem solving/resolution skills and demonstrated resourcefulness. Organization skills, attention to details, and the ability to prioritize in a changing environment. Ability to be impartial and objective. 3. CUSTOMER SERVICE Manages difficult or emotional customer situations well; responds promptly to customer needs; solicits customer feedback to improve service; responds to requests for service and assistance; meets commitments. 4. TEAMWORK Dedicated team player. Strong collaboration skills, ability to work effectively in a team environment as a positive team player and provide superior customer support. 5. ORGANIZATION SKILLS - Organization skills, attention to details, and the ability to prioritize in a changing environment. 6. LANGUAGE SKILLS - Ability to read and interpret documents written in English such as procedures, work instructions, and timesheets. Ability to effectively communicate with customers and coworkers. 7. MATHEMATICAL SKILLS - Ability to add, subtract, multiply, and divide in all units of measure, using whole numbers, common fractions, and decimals. 8. REASONING ABILITY - Ability to apply common sense understanding to carry out instructions furnished in written, oral, or diagram form. Ability to deal with problems involving several concrete variables in standardized situations. 9. OTHER DUTIES: a. Excellent customer service skills. Able to build good relationships with and relate well to end users. b. Extensive experience performing root cause analysis. c. Basic understanding of project management principles. d. Ability to thrive in a fast-paced environment. e. Able to solve complex problems. f. Ability to maintain confidentiality of sensitive information. g. Able to develop ideas and processes and clearly express them. h. Ability to work under pressure of deadlines of short term objectives while not losing sight of long term goals. i. Project and team management/leadership skills and experience. Proven ability to work effectively in a team environment with associates. Capability of effective planning and priority setting. Ability to manage several complex projects simultaneously while working under pressure to meet deadlines. EDUCATION and/or EXPERIENCE: BA/BS degree or equivalent training in IT, computer science, data analysis or other related fields. Minimum of 5 years of proven experience as a database developer, creating reports, and using BI tools such as Birst, Power BI, or Tableau for data analysis and reporting. Expert level knowledge of TSQL and SQL Server tools for table design, writing and optimizing high performing queries, views, functions and stored procedures. Significant expertise as a Microsoft SQL Server database developer. Significant experience with master data management (MDM) principles and techniques Significant experience with data cleaning and ETL solutions, SSMS, and SSRS. Significant experience troubleshooting and improving database performance issues Some experience integrating with third party applications at the database and web service layers. Some experience in a senior or leadership role. Some experience developing web applications and services with Microsoft Visual Studio Familiarity with developing and implementing requirements for software financial systems (billing and accounting). Proficiency with fundamental data representation concepts such as XML, JSON, Document Object Model (DOM), and RESTful services. In-depth experience with cloud solutions from Azure and/or AWS. Familiarity with low-code platforms such as OutSystems or Mongoose. Familiarity with Cold Fusion, Entity framework, ADO.Net, Git, and KendoUI. Familiarity with applications such as Jira, Confluence, ERP systems such as Great Plains. Thanks & Regards Sushmita Soni Sr. Technical Recruiter| SoniTalent Corp. Desk | 859-659-1004 EXT 201 [email protected] Address - 5404 Merribrook Lane, Prospect, KY, USA Keywords: csharp business analyst business intelligence information technology golang California Kentucky South Dakota |
| [email protected] View all |
| Tue Sep 12 22:27:00 UTC 2023 |