Database Developer

Roljobs Technology Services Pvt Ltd Portland , OR 97204

Posted 1 week ago

Apply

This Job is not relevant Tell us why

Title: Database
Developer
Location: Portland, OR
Job Type:
Direct full-time hire
Here are exiting responsibilities:

You will design, code, test, support and maintain data schemas and data flows related to the enterprise data warehouse.
You will design, code, test, support and maintain data integrations throughout the enterprise application portfolio.
You will work directly with business teams including Brewing Operations, Supply Chain, Strategy and Analytics, and Finance to deliver data-driven solutions that help them solve business problems and create new opportunities.

We would love to hear from you if :

You must have 5+ years of SQL programming experience with at least 3 years of programming experience with the Microsoft SQL Server toolset including SSIS.
You have experience with SQL Server Integration Services or similar ETL tools such as IBM Data Stage or Informatica.
You must have great understanding of BI and Data Warehousing concepts and techniques.

What's in it for you? Glad you asked !!
Excellent Base Salary + Bonus + Great Benefits Package.
We embrace diversity and equal opportunity in a serious way. We are committed to building a team that represents a variety of backgrounds, perspectives, and skills. The more inclusive we are, the better our work will be.

Show Full Description

See how you match
to the job

Upload my resume

Download the
LiveCareer app and find
your dream job anywhere

Similar Jobs

View All

Want to see jobs matched to your resume?
Upload One Now!

Senior Database Administrator (Ren 9733)

Avangrid

Posted 6 days ago

VIEW JOBS Overview The Database Administrator administers, maintains, develops and implements policies and procedures for ensuring the security and integrity of Avangrid's Oracle and PostgreSQL databases. Implements changes to production database objects and data as well as adhere to required best practices change management procedures. This person resolves Oracle database performance issues, database capacity issues, replication, Disaster Recovery, and other database issues. This person must be an experienced self-starter looking for ways to make improvements that will increase efficiency and maintainability of the database management systems to support a tightly integrated team of developers, system analysts, project managers and system owners. Given the unique nature of this team, this position presents a unique opportunity to participate in and contribute towards the data analytical functions pertaining to project work and support including data modelling and design. Responsibilities * Administer Oracle databases in Linux and AIX environments * Administer PostgreSQL databases in Linux environment * Ability to work effectively under pressure, meet deadlines and adjust to changing priorities * Monitor database performance, space usage and availability * Monitor database backup and export jobs to ensure proper recovery avenues are in place * Assist with application upgrade or maintenance projects as needed * Participate in monthly DR testing activities * Monitor Oracle replication environment and resolve issues * Monitor database account usage * Ensure compliance with established IT controls and audit requirements * Perform a variety of tasks and have a proven ability to work with minimal supervision * Assist with desktop client software installs and connection issues as needed * With Application support staff, assist with troubleshooting End-of-Day process issues * Refresh test databases with clones of production when requested * Participate in all upgrades and changes to Energy Trade and Risk Management applications * Perform data analysis and reporting * Maintain documentation * Ensure all changes have appropriate approvals and follow Avangrid Renewables change management policies Required Qualifications * Bachelor's degree in computer science, information systems, business, or an equivalent combination of education and experience * 5+ years of Oracle DBA experience * 2+ years of PostgreSQL experience * 2+ years of Linux/UNIX experience * Strong customer service attitude and ability to juggle multiple priorities * Strong written and verbal communication skills with the ability to effectively communicate with both business and technical personnel * Self-starter able to perform a variety of tasks and has a proven ability to work with minimal supervision, as well as in a team environment * Occasional weekend and after-hours work * Back-end (tier 3), on-call support for emergencies * Basic knowledge of shell scripting Preferred Qualifications * Self-motivated with a desire to stay abreast of latest technologies * Willingness to perform non dba functions such as data analysis and project work * Experience with Oracle BI, Weblogic * Experience with using data visualization platforms such as Tableau and MicroStrategy * Experience with Oracle Replication * Experience with working in IT for an energy company * Experience with FIS's suite of Energy Management applications * Experience with large databases All offers of employment are contingent upon the successful completion of a medical Fit for Duty exam, background check, references, drug screen, verification of legal right to work in the U.S., and in some cases, a credit check. A credit check will be administered when a prospective employee will be working in Finance, Accounting, Treasury or where duties may involve handling of funds, accounts or cash. A Motor Vehicle (MVR) check will be administered when a prospective employee will be regularly using a company vehicle. Avangrid Renewables is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, protected veteran status, status as an individual with a disability, or any other status or class protected by federal or state law. AVANGRID's employment practices and policies are geared to hiring a diverse workforce and sustaining an inclusive culture. At AVANGRID we provide fair and equal employment and advancement opportunities for all employees and candidates regardless of race, color, religion, national origin, gender, sexual orientation, age, marital status, disability, protected veteran status or any other status protected by federal, state, or local law. Learn more about equal employment by following this link If you are an individual with a disability or a disabled veteran who is unable to use our online tool to search for or to apply for jobs, you may request a reasonable accommodation by contacting our Human Resources department at 203-499-2777 or careers@avangrid.com

Sr Database Performance Benchmarking

Amazon.Com, Inc.

Posted 7 days ago

VIEW JOBS

Ruby On Rails React Developer

Planet Argon

Posted 3 days ago

VIEW JOBS Bonjour, Ruby on Rails + React Developers!Here's the deal; before our clients hire us, they've often already invested a lot of time, energy, and money into having custom web applications developed to help them solve some business challenges. They come to us looking for a team to provide dependable support and maintenance of their existing Ruby on Rails (and a handful of React) projects. We do this in the form of recurring retainers where we take care of small feature updates, bug fixes, performance improvements, chipping away at their technical debt, and helping them experiment as they navigate their forward as a business. What we rarely do? Is spin up brand new web applications for them. We learned years ago that there is rarely a long-term client relationship with startups (as they tend to flop in 1-2 years). So, we stopped competing on those projects. The tradeoff? We get to build lasting partnerships with our clients and have some influence on how they're planning for their life of their web applications. So...if you're the type of developer that really enjoys shiny and new things (and/or pitching entire app rewrites)... this probably isn't the position for you. If you're the type of developer that enjoys jumping into the deep end of complex projects, helping iterate and improve software, likes to take on responsibility and be given opportunities to help lead projects... then we should talk. Our Core Values PROACTIVE - We actively seek opportunities to improve our client’s products, our processes, and our abilities. CURIOUS - A natural curiosity for the undiscovered results in remarkable work for our clients – and stronger connections for our team. We ask questions, learn, and aren't afraid to fail. DEPENDABLE - We are invested in our work. We manage expectations. We support our clients and teammates. We hold ourselves, our teammates, and our clients accountable. VERSATILE - We readily adapt to change and encourage innovation because our team and work are transparent and flexible. DELIGHTFUL - We choose to set a mindful, positive tone that allows everyone to flourish. We are a small team and wear many hats. In addition to the list of responsibilities below we also expect all of our team members to participate in our marketing efforts, whether that’s you writing blog posts, offering to speak at a conference, or coming up with ideas for new initiatives. <a href="https://workable.com/nr?l=https%3A%2F%2Fwww.planetargon.com%2Fabout" rel="nofollow noreferrer noopener" class="external">Learn more about Planet Argon</a> What you'll typically be focused on... <ul> <li>Participating in short daily standups to outline what you completed yesterday and are aiming to accomplish today</li> <li>Balancing ~2-5 client projects/week (sometimes a few each day)</li> <li>Keeping an eye out for your teammates. Perhaps you could lend them a hand to tackle a challenge and/or vice versa</li> <li>Getting your head wrapped around a subset of our client projects and their business goals</li> <li>Partnering up with your project manager to figure out how to best prioritize your work this coming week</li> <li>Collaborating with your team members to help with these projects (from planning, estimating, coding, testing, and bug fixing)</li> <li>Documenting the tricks and lessons you learn to share with the dev community on our blog</li> <li>Asking clients for clarification on requirements that you aren't sure that you understand</li> <li>Being an advocate for the long-term health and maintainability of our client's projects</li> <li>Saying, "I don't know (yet) ... but I'll help figure it out!" to clients and peers</li> <li>Improving the overall test coverage of our client projects</li> <li>Helping pick out music to play on the studio stereo system (unless you're remote)</li> <li>Performing code reviews on your teammate's pull-requests</li> <li>Googling weird error messages...a lot</li> <li>Sharing praise when someone on the team does something amazing</li> <li>Occassionally helping out with DevOps/sysadmin tasks</li> <li>Sending your code for peer review</li> <li>Stumbling across possible fixes in API docs, Stack Overflow, and Github issues</li> <li>Taking advantage of our flextime scheduling to swing by the gym, go for a run before the rain starts, or maybe sitting in the park with a book</li> <li>Rolling your eyes as you look at that code that wasn't working and realizing the silly typo</li> <li>Capturing your "lesson learned" to share with the team this next Monday morning </li> <li>Communicating directly with clients to help define features/user stories, improvements to existing applications</li> <li>Writing, refactoring, and improving our client's web applications and APIs (...we have a few internal projects, too)</li> <li>Sending clients a link to a staging environment so they can test out your changes before you deploy to production</li> <li>Deploying code to staging/production environments</li> <li>Petting the dog that swings by your desk to say hi (unless you're remote...do you have your own dog to pet?)</li> <li>Tracking time for our client work so that we can pay our bills</li> <li>Appreciating when your teammates share their failures with you </li> <li>Sitting down with interns/junior developers to hone your mentoring skills (or popping on a screen share if you're remote)</li> <li>Removing noise in the README files that we probably should have cleaned up a while ago</li> <li>Thanking clients when they provide great requirements that helps you out</li> <li>Sharing your hard lessons/failures with your peers</li> <li>Noticing inefficiencies in our existing processes and taking note to raise it at our next team meeting</li> <li>Adding useful information to the README files that will help your teammates</li> <li>Carving out a little time each week to try out some new tools</li> <li>Sharing useful links with your peers in Slack</li> <li>Preparing a 5-to-10-minute talk on how to use said new tool for our next company workshop series</li> <li>Helping us become a better version of ourselves than we were yesterday</li> </ul>Requirements<ul> <li> 3.141592653+ years of experience with Ruby on Rails</li> <li>Ability to convey your thoughts/ideas verbally and written...with a delightful (and competent) tone</li> <li>Experience collaborating with clients/stakeholders/decisionmakers/mimes. (bonus points if you can read their minds)</li> <li>Some general concepts of how SQL database work and how to navigate them </li> <li>Comfortable with a Apple Mac environment (maybe you even like to dabble with Linux?)</li> <li>Know more than enough Git to be dangerous</li> <li>Experience writing automated tests for Ruby on Rails apps</li> <li>Using Capistrano, Git, etc to handle Rails deployments</li> <li>Knowledge of HTML and understanding of CSS/Sass</li> <li>Worked with JavaScript frameworks like React, Ember, Angular, and/or Backbone.</li> <li>Knowledge of software design patterns and experience with implementation</li> </ul> NOTE: If you're not in the Portland area -- you might be our first full-time remote employee! We have much to learn about working in that way. We have some good ideas on how to make this work well -- and will be mindful to take healthy steps together. It'll not be perfect but we want to explore this with you. Responses from freelancers, design studios or recruiters offering their services will be ignored.BenefitsAfter three months of full-time employment, we provide: <ul> <li>Medical & dental insurance (PLANET ARGON pays 80% of premium); </li> <li>SIMPLE IRA with 3% of employee salary match;</li> <li>Paid vacation that increases with your length of employment; (15 days accrued the first year, 20 days after the first year, and 25 days after three years)</li> <li>Five days of sick time each calendar year;</li> <li>Six paid holidays yearly;</li> <li>Periodic bonuses dependent upon company and employee performance; and</li> <li>Participation in our flexible work time policies.</li> </ul> We will perform background checks and request professional references from finalist candidates. We are an equal opportunity employer and value diversity at our company. We do not discriminate on the basis of race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status.

Apply