SUMMARY:

• I applied my professional experience to install, configure, administer, implement and manage various database related designs and resources (sql server/oracle,informix,sybase,db2,tableau,splunk and spotfire). I have experience designing, implementing, and maintaining relational database management systems that support enterprise - wide applications. I set up databases according to a company’s needs,datawarehouse,data mining, performance optimization and security, also fine-tune, upgrade and test modifications to the databases as needed before deployment in production,implement service packs. I resolve complex performance issues, so attention to detail is an essential trait in being a DBA and part of me, as is a passion for problem-solving.I have worked solving complex database related problems in several industries ranging from oil and gas, pharmaceutiocal, healthcare,biotech, insurance and life science companies jsp,applet,javabeans, javascript,R,html5,css,Ajax
• Big data skills: Tableau, powerBI,slamdata
• Hadoop,spark, maprrduce
• Mongodb/ couchdb/casaandra/ hbase
• Hives,hdfs,Oozie,hive,kafka
• Sqoo0,pigEclipse/
• Angular 2/4,NodeJS,Spring MVC,Bootstrap,Apache nifi,Kafka,Storm,Spark,Metron,Elastic search,Ibm Cognos,ibm guardium
• Graphics design: Adobe photoshop cc, illustrator cc, maya,3d studiomax, matlab,Autocad, Mathrmatika

TECHNICAL SKILLS:

Skills: UML, C, C++, SQL, .NET. Systems experience, UNIX, Solaris,HP - UX and Linux environments. Backup / Recovery: Symantec GHOST, Acronis TrueIMAGE, OnTrack, VSS, eFolder, rsync, VERITAS Backup Exec Anti-Virus / Filtering: Symantec AntiVirus Corporate, Kaspersky Enterprise, SmartFilter, GFI WebMonitor for ISA Server Operating systems: MS-DOS, Windows 95, 98, 2000, XP, NT 4.0, 2003 Server, VISTA, windows 7,windows 10, windows 2008 server,windows 2012 server Red Hat, Fedora Core, FreeBSD, LinSpire, Debian GNU Linux,hp-ux Server platforms: MS Exchange 2000/2003, VmWARE Server, MS Virtual Server, MS Operations Manager 2005, MS Live Communications Server 2005, MS IIS 6.0 / 7.0, Apache Webserver. Microsoft office 2007/2010/2013 MS Visio, Sybase, Informix Microsoft Database editions: SQL Server 2000, SQL Server 2005, SQL Server 2008, 2008 R2 SQL Server. 2012/2014/2016

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

Mongodb Database Administrstor

Responsibilities:

• Experience in performing Mongo DBA operational routines;
• MMS configuration experience, Configuring and monitoring replica setsOptimizing database/query performanceConfiguring Sharding, monitoring, and identify the proper shard key
• Performing Security measures, backups and restore backups
• Working knowledge of monhodb and cassandra
• User Management - creating users, assigning roles, managing permissions

Confidential, Houston, TX

Sr Database Administrator/security administrator

Responsibilities:

• SSIS,SSRS,SSAS and data warehousing, tableau report and cognos for data integration,transformation and mining.
• Experience in performing MongoDb and cassandra DBA operational routines;
• MMS configuration experienceExperience configuring and monitoring replica setsOptimizing database query performance
• Performing security measures, backups and restore backups
• Experience in User Management - creating users, assigning roles, managing permissions
• Worked on IBM guardium for database security and DB2 database server with
• 3+ years of experience with IBM Guardium activity monitoring and vulnerability scanning and assessmet
• ·Experience on database masking and database vulnerability
• ·Experience with great understanding of using information security tools and systems experience
• ·knowledge of process definition and documentation experience
• ·Knowledge and understanding of application security planning and security architecture
• Knowledge and understanding of information security risk assessment or audit
• ·Experience with Database authentication tools, database firewall and encryption
• ·Excellent verbal and written communication skills and Advanced Information Security technical skills
• ·Ability to manage complex issues, analyze them and develop solutions
• Experience with security frameworks and regulations i.e. PCI DSS, SOX, SOC1, GLBA, NIST, ISO 270001
• Performed database upgrades from 2008 r2 to 2-012,2014 and 2016 edition of Microsoft sql server fine tune and optimize verycomplex queries Apply patches, maintained and managed all client user account Performed disaster recovery and setup replication to remove load on the production server by pulling reports from the secondary server, Experience troubleshooting all performance related issues
• SSIS,SSRS,SSAS, tableau report and cognos for data integration,transformation and mining.
• Apache hadoop, spark, hive, jira. Nosql
• Performed query aggregation and optimization
• Cloud Platform implementation and integration of Amazon web services and Microsoft Azure and web services
• Practise of agile and scrum computing

Confidential, Houston, TX

Sr Database Administrator

Responsibilities:

• Expat knowledge of MongoDB, cassandra,microsoft sql server and oracle experience in performing Mongo DBA,sql server,cassandra operational routines;
• MMS configuration experience, Configuring and monitoring replica setsOptimizing database/query performanceConfiguring Sharding, monitoring, and identify the proper shard key
• Performing Security measures, backups and restore backups
• User Management - creating users, assigning roles, managing permissions managed server backup, storage and partitions fine tune complex queries and setup maintainance jobs on the servers roubleshoot all performance related issues Apply patches, maintained and managed all client user account maintain the existing clusters and managed Cisco firewalls and concentrators for security purpose using tableau and splunk to analyze Big complex data (sql,apache hadoop,spark,hive,jira, nosql)
• C#,c++
• IBM data security with guardium And classification of data to vulnerability assessment To data and activity monitoring 5+ years oracle 9,10g,12c database administration, support high availability architecture including always on and VLDB. - Extensive knowledge of oracle RAC
• High availability SQL Server Clustering ( installing, configuring and administering a clustered sql server. implemented Microsoft failover clustering with high availability .it improves the availability of physical server hardware, operating system and SQL server instances.
• SSIS/SSAS,SSRS and crystal reports troubleshooting and configuration and built some new drill down and drill-through reports for the management to make some key business decisions.
• . New packages creation and troubleshooting the existing packages
• Converting. Old written stored procedures and business objects into packages Using business intelligence development studio to develop business intelligence solutions
• Database migrations of Data from SQL 2000/2005/2008/2012/2014
• Script execution and jobs creation and scheduling.
• SSIS/SSAS,SSRS
• Data mining with SSAS
• OLAP Cube designs and MDX Queries
• Database log shipping, Database mirroring and Replication Setup for disaster recovery.
• Datawarehouse implementation and designs with SSIS
• Extraction Transformation and Loading (ETL) of data from different platforms into SQL server tables and databases for further processing and analysis.
• Worked on IBM Guardium activity monitoring and vulnerability scanning and assessment
• Worked on database vulnerability and security assesment, data masking and process definition and use various nformation security tools
• Experience with security frameworks and regulations i.e. PCI DSS, SOX, SOC1, GLBA, NIST, ISO 270001
• Medidata solutions- Houston, Texas Sr Database Administrator
• Managed up to 25,000 databases in production, development, staging, UAT and sandboxes for global pharmaceutical companies, biopharm, biotech, contract research organizations and the medical device companies.
• Extreme backup and recovery
• Replication and database mirroring setup for various clients
• User account creation, modification and deletion
• Data transformation with DTS and SSIS for Data warehouse for extraction, transformation and loading
• Bbuilding server based drilldown and drillthrough reports with SQL server reporting services and business intelligence studio
• OLAP cube designs with sql server analysis services and designing pivoted tables
• Ddatabase refreshes from production to sandboxes and development environments
• Database restores with symantech netbackup software
• Tape archive of client databases to an external environment
• Knowledge of VMware and cloud computing for database in production
• Monitoring tools:prtg, performance co pilot, nagios,icinga,abturis,,opennms,op5,relic, monitis

Confidential, Houston, Texas

Global Database Adminstrator

Responsibilities:

• Monitor and maintain over 7000 Global SQL Servers in Production, QA, Test, Development and staging Environments.
• Verify backups and error logs on the servers and troubleshoot any failures or alerts, open trouble tickets if necessary to work with application developers from other departments
• Respond to problematic ovsd tickets assigned to me and fix any database issues promptly
• Identified and resolved SQL Server Database locks and hardware - related issues, using SQL Server Profiler and SQL Server Query Tuning & Diagramming where necessary, to resolve Performance slow-downs due to blocking and other index issues, etc. se Locking and the appropriate Isolation level hints to minimize blocking, and identified SQL Server configurations that is out of specs. Avoid transactions that require user input to commit and long-running transactions.
• Perform data Backup/updates and exports between SQL Servers, both internal and external as required. Wrote & debugged stored Procedures & Triggers using T-SQL and take infrastructure restrictions into account, in the schema design.
• Implemented Log-Shipping as high availability solution using both Enterprise and Standard SQL Server 2000 editions.
• Automated backup and recovery processes through out the environment and Automated SQL Server error log notification process without using SQL Server agent service
• Managing SQL Server clusters and Migration process from different data sources to SQL Server and Performance tuning of Database and SQL statements.
• Building OLAP cubes for DSS system and Setting replication servers using replication methods of SQL server and Administration of SQL Servers such as creating databases, security mechanisms, Auditing, maintaining proper backups
• Iimplemented clustering solutions and setup and manage replication services, management tools with extensive experience with replication from (SYBASE to SQLServer), and (SQL2k to SQL2005) and (SQL2k5 to SQL 2k5 )

Confidential, Gainsville,Florida

Network Security Engineer/DBA

Responsibilities:

• Diagnose low level SQL Server bottlenecks by using SQL Profiler, interrogating internal system tables and using various other utilities.
• Design creative and supportable technical solutions to challenging problems, as needed.
• Write thorough technical change plans, as needed.
• Design end - to-end solutions with Microsoft technologies, which may include but is not limited to, load balanced servers IIS servers, Report Services, n-tier servers, SQL Server clustering, SQL Server notification services, SQL Server log shipping, Microsoft Business Intelligence Suite and Web Services.
• Deploy complex SQL Server Integration Services packages.
• Assist customers with ADO.net issues with SQL Server as the data store.
• Consult internal and external customers regarding Enterprise level SQL Server design and/or end-to-end solutions to meet proposed business needs.
• Design complex SQL Server clustering, replication and log shipping models, which may involve servers across various networks.

Confidential, Houston, Tx

DBA/Network Administrator

Responsibilities:

• Managed an active directory network consisting of 500 users of Window 2000 Pro.
• Created, configured and troubleshoot email accounts with Exchange 2000.
• Cabled, configured and setup computers, peripherals.
• Created and administered all user accounts with Windows 2000 Active Directory.
• Troubleshoot all PC and network related issues.
• Performed PC upgrades and ghosting services using Norton's.
• Installed and maintained Exchange, DHCP, WINS, and backup servers.
• Provided Level III support to mail users.
• Troubleshoot all Nortel PBX phone issues.
• Diagnosed and perform network administration, maintenance and monitoring.
• Configured and troubleshoot VLAN for the Local Area Network.
• Installed and configured RAID drives for all servers.
• Responsible for all ISDN issue for Polycom phone conferencing.
• Install and troubleshoot Citrix client connection and Cisco VPN access.

Confidential

Network and Exchange Administrator

Responsibilities:

• Installed and maintained entire network, including cablng for the office as well as preparing computer resources including servers, workstations, laptops, printers, and multimedia equipment.
• Administered a Windows NT 4.0 domain environment which includes user accounts assignment, access controls and file permissions, security and system patches, and storage backup.
• Standardized suites of desktop software products allowing greater ease in document sharing, as well as the ability to upgrade software remotely and to troubleshoot more efficiently.

Confidential

Database Developer/IT Support

Responsibilities:

• Designed and implemented Database system to track temporary employees wages, time worked as well as client information. Consolidated a three step process into to one step saving time and increasing accuracy.
• Also built Customized reports using report designer in sql server 2000.Prepared reports on status, operation, and maintenance of system software. Within two weeks decreased the amount of time on the close process construction files from 3 days to 10 minutes. Built a database that tracks all resources (hours, materials, wages etc..) for construction projects.
• Wrote data extraction scripts and queries to support the generation of reports. Test and validate integrity of data for reporting accuracy.

Confidential

Database Administrator/Developer

Responsibilities:

• SQL Server Database Administrator/Developer for a large call center.
• Involved in data warehousing, interactive voice response and .NET programming.
• Successfully developed and implemented a T - SQL based billing system that improved the accuracy and timeliness of customer invoicing. Collaborated with accounting and billing managers. Managed data modeling and programming issues.
• Re-wrote many of the .NET 'code behind' functions for applications to utilize SQL stored procedures instead of hard coded SQL queries. This protected the company data from the danger of 'SQL injection' attacks on their web pages.
• Perform Tier 3 troubleshooting and support for complex issues.
• Provide escalated implementation support.
• Create and update technical documentation, as required and Provide technical, as needed.
• Implement enterprise level toolsets and measures to ensure the efficient management of SQL Server instances across the enterprise.