SQL Database Developer
Постоянная работа в Одесском офисе крупной продуктовой американской компании.
Job Description
OpticsPlanet, Inc. is seeking a full-time SQL Database Developer, who will be responsible for development within our MS SQL Server environment. The ideal candidate has a background in database development and must be willing to be flexible with priorities as they change rapidly in our dynamic fast-paced environment.
Primary Duties and Responsibilities
· Develop complex stored procedures, functions, triggers, views and queries in support of application development
· Participate in application development projects
· Review and optimize existing stored procedures, functions, triggers and queries
· Convert existing embedded SQL code into stored procedures
· Develop custom scripts to automate various database management processes
· Occasionally write single-time reports on demand
· Develop various ETL jobs for our Data Warehouse
· Define and review best practice standards for data integrity
Requirements
· Bachelor's degree in Computer Science, IT or related field
· At least 2 years of professional work experience
· Strong problem solving skills
· Positive attitude and strong work ethic
· Ability to meet multiple deadlines in a multitasking environment
· Strong written and verbal communications skills
Qualifications
· Experience in T-SQL, procedures, functions, triggers, views and queries
· Experience with SQL Server 2012/2014
· Experience with SSRS, SSIS, & SSDT
· Proficiency with Microsoft Office 2010/2013/365
· Working knowledge of MySQL databases
· Knowledge of data warehousing and data mining
Benefits
· Great Agile teams full of talented developers.
· Autonomy to pursue personal career goals and technical interests on company time.
· Managed career growth and opportunity for advancement in a transparent work environment.
About OpticsPlanet
When it comes to high-performance technical gear, the most discerning customers choose OpticsPlanet for our unmatched value proposition of great prices, free shipping on most orders, the widest selection (over 1 million products) and excellent customer service. We’re proud of all that – and what makes it possible is that the most talented professionals in the Chicago area choose to work at OpticsPlanet.
OpticsPlanet is a leading internet retailer devoted to the passions and professions of our customers. From hunting or sports shooting to service in the military or law enforcement, we are a destination for millions of people each month. For over fifteen years, we've built a cutting-edge platform that powers ecommerce heavyweights such as OpticsPlanet.com and Dvor.com. We are experiencing a new phase of explosive growth and opportunity, and that means adding more talented and passionate individuals to our existing diverse and professional team. Our casual, fast-paced environment has seen us recognized as one of the "100 Best Companies to Work For" by the Chicago Tribune! In addition to a challenging position, employees at all levels can find extensive opportunities for advancement and career growth, and full-time employees enjoy a popular set of benefits and perks. OpticsPlanet is an Equal Opportunity Employer.
CONTACTS
Skype — barrracuda
telegram @softesis
viber +380975436333
www.facebook.com/maria.belonozhko
Applications 1
-
1 day23 USD
164 1 day23 USD
Добрый день.
ЗП от 85 000 если в Одессе. От 60 000 если удаленно/частично удаленно (могу 1-2 недели работать в офисе, остальную часть времени удаленно).
С уважением, Евгений.
Current freelance projects in the category Databases & SQL
Technical task: Integration of Telegram chatbot with BAS1. General Description It is necessary to implement the integration of the chatbot with the BAS system for the transfer and recording of data about products (orders). 2. Input Data (sent by the chatbot): Group ID Product name (with product code) Product price 3. Logic of… Enterprise Resource Planning (ERP), Databases & SQL ∙ 28 minutes back ∙ 2 proposals |
1C database for the enterpriseA database is needed for managing the auto dismantling inventory, controlling finances, and generating orders. It is necessary to add a car as an object and attach parts to it. I will explain the full structure of how it should look and work during the conversation. Databases & SQL ∙ 10 hours 2 minutes back ∙ 5 proposals |
1C data integration
Organize quality preparation and data transfer from 1C to BigQuery for further use in Looker:Organize the data according to the required fields.Prepare a clear structure of tables and intermediate datasets on which dashboards will be built.Set up data loading, gather key… Databases & SQL, Data Processing ∙ 1 day 15 hours back ∙ 9 proposals |
Development of a simple controlling and management record system in Google Sheets "turnkey"
Task name: Development of a simple controlling and management record system in Google Sheets "turnkey" for a construction company in Poland (+ online training and implementation assistance) About the company, context, and my main problem Hello, I am looking for an experienced… Databases & SQL, Accounting Services ∙ 2 days 20 hours back ∙ 33 proposals |
Development of an analytical Power BI dashboard
45 USD
This is our request, we need a person who understands Power BI: Screen 1: Strategic Cockpit (Financial Health of the Plant) Goal: To understand in 5 seconds, "where are we losing money and how much?". KPI Tiles (Top Bar): Overall margin (Actual vs Plan) in %. Amount of "lost… Databases & SQL ∙ 3 days back ∙ 13 proposals |
Odessa