There are many IT companies in US, but none quite like NanoSoft. We’ve been around for over 30 years but you wouldn’t guess it from the energy in the place. Along the way, we have picked up plenty of awards, we currently rank 3rd in the Great Place to Work’s Best Workplaces and have been a Deloitte Best Managed Company for over 10 years.
DEPARTMENT
Database Administrator
LOCATION
Maltepe / İSTANBUL
POSITION LEVEL
Senior
JOB TIME
Permanent / Full-time
The ideal candidate should;
Candidates can look forward to regular client contact, a role in business development and proposal writing/methodology creation, and a
- Build database systems of high availability and quality depending on each end user’s specialised role
- Design and implement database in accordance to end users information needs and views
- Define users and enable data distribution to the right user, in appropriate format and in a timely manner
- Use high-speed transaction recovery techniques and backup data
- Minimise database downtime and manage parameters to provide fast query responses
- Provide proactive and reactive data management support and training to users
- Determine, enforce and document database policies, procedures and standards
- Perform tests and evaluations regularly to ensure data security, privacy and integrity
- Monitor database performance, implement changes and apply new patches and versions when required
- Proven working experience as a Database administrator
- Hands-on experience with database standards and end user applications
- Excellent knowledge of data backup, recovery, security, integrity and SQL
- Familiarity with database design, documentation and coding
- Previous experience with DBA case tools (frontend/backend) and third party tools
- Familiarity with programming languages API
- Problem solving skills and ability to think algorithmically
The Developer is expected to;
- Translate business requirements into specifications that will be used to drive data store/ data warehouse/ data mart design and configuration
- Use ETL tools to load data store(s)/ data warehouse(s)/ data mart(s).
- Transition developed BI systems to the Operations & Support team
- Provide support as required to ensure the availability and performance of enterprise data and BI environments for both external and internal user
- Ensure proper configuration management and change controls are implemented for your sphere of influence
- Provide technical assistance and cross training to other team members
- Design and implement technology best practices, guidelines and repeatable processes
- Must be able to perform duties with moderate to low supervision
- 3+ years experience implementing enterprise-scale reporting systems, including
- Working with users in a requirements analysis role
- Extensive use of SQL and RDBMS systems (DB2, Oracle, SQL Server, etc.)
- Extensive experience with data warehouse implementations
- Strong knowledge of logical and physical data modeling concepts
- Proficiency with Cognos BI (preferably v10.x) (Framework Manager, Transformer, Metrics Server, Analysis Studio, Report Studio, Query Studio, etc.)
- Cognos Administration and security management is a plus
- Demonstrated ability with ETL tools. Familiarity with Informatica is a plus.