Database Developer

Roljobs Technology Services Pvt Ltd Portland , OR 97204

Posted 2 months ago

Apply

This Job is not relevant Tell us why

Title: Database DeveloperLocation: Portland, ORJob Type:
Direct full-time hireHere 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!

Data Architecture Intern Database Services Summer 2021

Blackberry Limited

Posted Yesterday

VIEW JOBS

Senior Database Administrator (Sql Server)

Northwest Evaluation Association

Posted 1 week ago

VIEW JOBS Senior Database Administrator / DBA III About this role… NWEA has an immediate need for a senior level Database Administrator. As a SQL Server DBA, you will be responsible for the implementation, configuration, maintenance, and performance of all SQL Server systems to ensure the availability and consistent performance of NWEA's applications. This is a full-time position with competitive compensation, an exceptional benefits package, and opportunity for career advancement. Your next challenge… * Manage SQL Server databases through multiple product lifecycle environments from development to mission-critical production systems. Configure and maintain database servers and processes including monitoring system health and performance, to ensure high levels of performance, availability, and security. * Test and configure database backups to meet the business s Recovery Point Objectives (RPO) and Recovery Time Objectives (RTO). * Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end. Determine the most effective way to increase performance including hardware purchases, server configuration changes, or index/query changes. Assist developers with complex query tuning and schema refinement. * Provide application developers with feedback on resource-intensive queries on the server and suggesting ways to improve performance on each. Design indexes for existing applications, proactively monitor query performance, and determine when to add or remove indexes. * Troubleshooting SQL Server service outages as they occur, including providing On call support during after-hours and weekends. After-hours work may also include, but not limited to scheduled maintenance, supporting application deployment, and hardware/software upgrades. * Plan and schedule the installation and configuration of new SQL Servers. Analyze the requirements for new projects and determine whether to use clustering, log shipping, mirroring, Windows Azure, or other technologies to solve a business problem. * Implement SQL Server monitoring utilities; refine and automate regular processes, track issues, and document changes. Configure access levels for each segment of the database. * Share expertise with team members providing technical mentorship and cross-training as needed. Traits for success… * Expertise in/hands-on experience with failover clustering, SAN replication, and other high availability technologies. * Hands-on experience with SQL Server patching and upgrades. * Experience with developing scripts for SQL Server Backup, Integrity Check, and Index and Statistics Maintenance. * SQL Server merge, peer to peer, or transactional replication. * Analysis Services, Integration Services, or Reporting Services. * Experience in Enterprise Design for high volume, transactional environments. * Experience in virtualized environments. * SQL 2012 2016 MCTS, MCITP, and/or MCDBA certifications are a plus. Competencies… * Customer focus: Building strong customer relationships and delivering customer-centric solutions. * Drives results: Consistently achieving results, even under tough circumstances. * Communicates effectively: Developing and delivering multi-mode communications that convey a clear understanding of the unique needs of different audiences. * Instills trust: Gaining the confidence and trust of others through honesty, integrity, and authenticity. Education and experience… * Bachelor's degree in Computer Science or a related field from an accredited four-year college or university * Minimum 5 to 7 years in support of a MS SQL Server Administration operating system, database management system * Minimum 5 years' experience with Microsoft SQL Server 2012 and/or 2016 & higher * Minimum 5 years' experience with Performance Tuning and Optimization (PTO) * Experience with Active Directory (one year) * Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server * Understanding of different database models and styles (OLTP, OLAP) * Experience testing and configuring database backups to meet the business Recovery Point Objectives (RPO) and Recovery Time Objectives (RTO) About us… NWEA® is a research-based, not-for-profit organization that supports students and educators worldwide by creating assessment solutions that precisely measure growth and proficiency-and provide insights to help tailor instruction. For 40 years, NWEA has developed innovative pre-K-12 assessments, including our flagship interim assessment, MAP® Growth™; our progress monitoring and skills mastery tool, MAP® Skills™; and our reading fluency and comprehension assessment, MAP® Reading Fluency™. Educators trust our professional learning offerings to accelerate student learning and our research to support assessment validity and data interpretation. Our tools are trusted by educators in more than 9,500 schools, districts, and education agencies in 145 countries. What we can offer you… At NWEA we not only offer a competitive base salary, we offer a 15% contribution of eligible employees' base salary to a defined contribution 403(b) retirement savings plan; career development opportunities; an awesome work culture and environment; we also offer industry leading benefits and perks that are focused on supporting our employees' holistic wellbeing. To learn more about what we can offer more, click here. NWEA strives to make diversity, equity, inclusion, and accessibility (DEIA) practices the center of our work. Our organization's mission, Partnering to Help All Kids Learn, is the foundation for our DEIA commitment as we work to reflect, value, and support the educators, students, colleagues, and communities we serve. We seek to empower and engage all stakeholders in the research, services, solutions and products we provide, our organizational culture, and the partnerships we establish with schools, districts, states, and countries. NWEA endeavors to make www.nwea.org accessible to all users. If you would like to contact us regarding the accessibility of our website or need assistance completing the application process, please call us at (503) 624-1951 or e-mail us at onlineaccommodations@nwea.org and let us know the nature of your request, your location and your contact information. This is for accommodation requests only and cannot be used to inquire about the status of applications. NWEA is an equal opportunity employer. Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or protected veteran status. For our EEO Policy Statement, please visit our website. If you'd like more information on your EEO rights under the law, please visit the EEOC website

Senior Database Administrator (Dapr)

Multnomah County, Oregon

Posted 1 week ago

VIEW JOBS Current employees: Please apply through the employee portal to be considered for this opportunity. Pay Range: $48.24 - $59.29 Hourly Department: Department of County Assets (DCA) Job Type: Regular Represented Exemption Status: United States of America (Non-Exempt) Closing Date (Open Until Filled if No Date Specified): January 24, 2021 The Opportunity: Overview This Work Matters... Are you a collaborative database administrator with an agile-focused approach to development? Do you have advanced experience in MS SQL Server Management Studio and Visual Studio, who designs complex systems with automation in mind? Are you ready to make an impact in your community? Multnomah County is looking for an IT Senior Database Administrator to be responsible for the design, development, tuning, maintenance and administrative of Enterprise SQL Server database environments. In this role, your primary focus will be on: Database Administration, troubleshooting, maintenance and support: * Administer database components (i.e., containers, tablespaces, tables, indexes, views, etc.) for on-premise as well on cloud. * Administer database security, monitor and correct space utilization. * Design and implement physical and logical database backups and perform database restorations. * Develop and maintain OS command scripts to support a variety of database maintenance activities * Develop and schedule database maintenance jobs, Troubleshoot database problems which involves analyzing the problem, identifying alternative solutions, projecting the consequences of proposed actions and implementing a solution. * Develop and schedule database maintenance jobs as well as analyze and troubleshoot problems, and implement solutions. * Plan and execute database object migration between development, test and production environments * Ensure compliance to promotion and deployment of applications to production environments following established promotion and change control processes. * Coordinate with software developers and business analysts to provide input on data conversion, integration, and defect repairs. * Perform installation, upgrades, patches for supported COTS applications and database software release. Database Architecture and Development: * Create architectural models and evaluate architecture, technology and product alternatives. * Plan, define requirements, design, develop, and maintain logical and physical data models for complex decision support and transaction processing systems. * Develop, maintain and optimize the most complex SQL statements and shared database objects across multiple DBMS platforms. * Create and maintain jobs, dynamic database objects, tables, files, and indexes to support computer applications using SQL, functions, stored procedures, triggers and views. * Design, build and deploy effective ETL solutions and provide maintenance, troubleshooting, support and performance improvements. * Develop physical architecture for real-time data management designs and off-line repository stores. Interact with network administrators to ensure confidentiality, security, scalability, and recoverability of data/databases. Database Performance Tuning and Standards: * Monitor performance, identify bottlenecks and recommend and/or perform adjustments to optimize performance * Automate the management of database server performance tuning and database life cycle utilizing database administration tools. * Research software alternatives/upgrades to improve security, performance, reliability, and recoverability of DBMS. * Plan, coordinate, and perform software and database migration for software upgrades. * Develop standards for metadata and interact with business analysts and application developers to ensure accuracy of metadata. * Develop standards and procedures for data extraction, cleansing, and transformation to ensure statistically valid data. Project Management and Technical Assistance: * Collaborate with project managers and business users and assist in troubleshooting complex SQL statements and database problems * Provide assistance with the installation of database client software * Participate in data quality efforts and in architecture design * Create or provide assistance with database models * Perform manual and automated administration of web environments. Continuous Integration and Delivery: * Architect and design complex systems and processes to automate and script application specific build and deployment needs. * Manage, plan, and coordinate system changes and deployments of those changes into support systems as needed. * Develop and maintain automation scripts that are standard and reusable across applications. * Administration of DevOps infrastructure and tools supporting the DevOps processes. * Develop and maintain standards related to DevOps practices. * Automate build, testing , and deployment tasks for custom applications, COTS applications, on-premise applications, and cloud applications. A Little About Us: Multnomah County IT is one of the most innovative government IT organizations in the nation, dynamically aligning itself with emerging industry trends. We are a group of creative, smart, and talented people who foster an inclusive environment of collaboration and fun. Our strength is the diversity of our people. To Qualify: We will consider any combination of relevant work experience, volunteering, education, and transferable skills as qualifying unless an item or section is labeled required. Please be clear and specific about how your background is relevant. Minimum Qualifications/Transferable Skills: * Bachelor's degree (in lieu of degree, equivalent years of experience will be considered) * 5 years of experience in IT development and database administration * Advanced knowledge and experience of: * RDBMS management tools, including MS SQL Server Management Studio * Installing, performance tuning, maintaining, securing and administering a MS SQL Server database environment * Installing, performance tuning, maintaining, securing and administering a MS Integration Server (SSIS) environment * Security, authorization and authentication in Microsoft Active Directory * MS SQL Server backup and recovery design and implementation * Developing on a SQL Server platform using Transact SQL (T-SQL) including stored procedures, query plans, functions, views, indexes and triggers * Database modeling, data conversion and ETL tools such as SSIS * Basic knowledge and experience of: * Microsoft Windows Server Administration * Administrative Scripting (C#, WMI, PowerShell, Rs Utility, MSBuild) * MS Windows Server high availability technologies, Application Development, architectures, languages, and/or tools * Developing and managing database in cloud computing environment (Microsoft Azure) * DevOps and CI/CD activities * Ability to pass a criminal history record check Screening and Evaluation The Application Packet: * A completed online application. * A resume covering relevant experience and education. Please be sure your resume includes the following for each employer: name of employer, location, dates of employment, your title, a brief summary of your responsibilities, the number of employees under your supervision. * A cover letter that expands on your resume, addresses why you are interested in this position and demonstrates how your experience and skill set aligns with the minimum and preferred qualifications listed. Note: The application, resume and cover letter should demonstrate your work experience/skills and how it is related to those shown in the Overview and To Qualify sections of the job announcement. Please be thorough, as these materials will be scored and determine your eligibility for an interview. The Selection Process: For details about how we typically screen applications, review our overview of the selection process page. We expect to evaluate candidates for this recruitment as follows: * Initial review of minimum qualifications: We may do an additional preferred review and/or send out additional supplemental questions to identify those highest qualified. * Evaluation of technical knowledge, skills, and abilities: There is a virtual scored evaluation session with the hiring manager to review the required technical skills and knowledge for this position. * Consideration of top candidates: We will consider qualified candidates in order of rank and score from the list of eligible candidates. This may include panel interview(s), a hiring interview, and/or additional testing to determine the best candidates for a position. * Background check and reference checks: All finalists must pass a thorough a criminal record check and reference check. ADDITIONAL INFORMATION: This recruitment may be used to fill full-time, part-time, temporary, limited duration and on-call positions. Type of Position: This hourly union represented position is eligible for overtime. Location: Multnomah Building - 501 SE Hawthorne Blvd. Schedule: Monday - Friday 8:00am - 4:30pm. There is some flexibility with the start and end times and a possibility of an alternative schedule after an initial orientation to the position. Diversity and Inclusion: At Multnomah County, we don't just accept difference; we value it and support it to create a culture of dignity and respect for our employees. We are proud to be an Equal Opportunity Employer. We evaluate qualified applicants without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran or protected veteran status, genetic information and other legally protected characteristics. The EEO is the Law poster is available for your reference. Multnomah County is a VEVRAA Federal Contractor. We request priority protected veteran referrals. Veterans' Preference: Under Oregon Law, qualifying veterans may apply for veterans' preference. Review our veterans' preference page for details about eligibility and how to apply. Accommodation under the Americans with Disabilities Act: We gladly provide reasonable accommodation to anyone whose specific disability prevents them from completing an application or participating in this recruitment process. Please contact the recruiter below in advance to request assistance. Individuals with hearing or speech impairments may contact the recruiter through the Telecommunications Relay Service by dialing 711. Questions? Recruiter: Tomas Tellez Email: tomas.tellez@multco.us Phone: +1 (503) 9882440 x82440 Application information may be used throughout the entire selection process. This process is subject to change without notice. Disclaimer: This announcement is intended as a general descriptive recruitment guide and is subject to change. It does not constitute either an expressed or implied contract. Job Profile: 6408 - Database Administrator Senior

Apply