Position: DBA, Database developer
Category: SQL
English level: intermediate
Years of experience: 4


I'm a DBA in a product company. I've been developing  database structures for 4 years.
Experience:
- experience in creating dbs
- experience in writing stored procedures, functions, views,  jobs
- experience in administering databases: restore, backup, clean dbs, control access permission, monitoring jobs and correcting errors in realtime dbs
- designing and implementing real-time ELT pipeline 
- data warehouses design and development
- modification and optimization of existing code to increase processing speed
- testing databases and applications, finding and fixing bugs and making modifications if necessary
- setting up data download traffic between servers
- writing stored procedures for report tables that are used in Power BI and Tableau
- writing analytical queries and reports on requirements for partners
- validation and data analysis
- synchronization of schemas and data bases
- working with XML and JSON formats
- supporting dev, qa and support teams when they need specific expertise
Skills:
- MSSQL 2014+, T-SQL, Excel(a little experience in VBA), XML
- VS, Visual Studio Tools, UML
- OLTP/OLAP, ETL
- ability to read other developers' code and making necessary changes
- Elasticsearch, Kibana